Is there any way to read the ms excel datas directly into informatica?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

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?

1 Answers   Amdocs,


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

2 Answers   TCS,


What is IQD file?

1 Answers  


How do you join more than 3 flat files in informatica?

1 Answers   ITC Infotech,


How do you do error handling in Informatica?

1 Answers  






How can repository reports be accessed without sql or other transformations?

0 Answers  


 Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,


What is the Difference between sorter and aggregator?

2 Answers  


Can we create a node as a gateway node and the same node can be assigned to a grid?

0 Answers  


Explain about Recovering sessions?

1 Answers  


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?

6 Answers   Accenture,


wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,


Categories