Is there any way to read the ms excel datas directly into informatica?
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?
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
What is IQD file?
How do you join more than 3 flat files in informatica?
How do you do error handling in Informatica?
How can repository reports be accessed without sql or other transformations?
 Code page compatibly –Where all changes are made to handle the scenario.
What is the Difference between sorter and aggregator?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Explain about Recovering sessions?
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
wht target override?wht advantages it has compare to target update?