Can a joiner be used in a mapplet.
How the informatica server sorts the string values in Rank transformation?
The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?
why we use source qualifier transformation?
What is difference between a connected look up and unconnected look up?
What are the ETL tools available in DWH?
Why union transformation is an active transformation?
How can we handle two sessions in informatica?
What are the reusable transforamtions?
If we set dd_insert in mapping and Delete in session properties what will happen.?
What is Cognos script editor?
Which are the different editions of informatica powercenter that are available?
what is diff between grep and find