*Filter candidates using TestYourCandidate.com and save 80% time ( saving time for recruiters and interviewers)
*More than 50% candidates can be filtered on Candidate Screening online tests
*Inbuilt exams are available in library, created and tested by experts Try Today...
Whether are not the session can be considered to have a heterogeneous target is determined? view answer
Under what circumstance can a target definition are edited from the mapping designer. Within the mapping where that target definition is being used? view answer
Can a source qualifier be used to perform a outer join when joining 2 database?
view answer
If u r source is flat file with delimited operator.when next time u want change that delimited operator where u can make? view answer
If index cache file capacity is 2MB and datacache is 1 MB. If you enter the data of capacity for index is 3 MB and data is 2 MB. What will happen? view answer
Difference between next value and current value ports in sequence generator? view answer
How does dynamic cache handle the duplicates rows?
view answer
How will u find whether your mapping is correct or not without connecting session?
view answer
If you are using aggregator transformation in your mapping at that time your source contain dimension or fact? view answer
My input is oracle and my target is flat file shall I load it? How?
view answer
I have the Administer Repository Privilege, but I cannot access a repository using the Repository Manager. view answer
My privileges indicate I should be able to edit objects in the repository, but I cannot edit any metadata. view answer
How does read permission affect the use of the command line program, pmcmd? view answer
I do not want a user group to create or edit sessions and batches, but I need them to access the Server Manager to stop the Informatica Server. view answer
I created a new group and removed the Browse Repository privilege from the group. Why does every user in the group still have that privilege? view answer
After creating users and user groups, and granting different sets of privileges, I find that none of the repository users can perform certain tasks, even the Administrator. view answer
A transformation is a repository object that generates, modifies, or passes data. You configure logic in a transformation that the Informatica Server uses to transform data. The Designer provides a set of transformations that perform specific functions. For example, an Aggregator transformation performs calculations on groups of data.
Each transformation has rules for configuring and connecting in a mapping. For more information about working with a specific transformation, refer to the chapter in this book that discusses that particular transformation.
You can create transformations to use once in a mapping, or you can create reusable transformations to use in multiple mappings.