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

Different qualification between a related rotate toward the sky and isolates look upward?

0 Answers  


What is a configuration management?

1 Answers  


I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance

4 Answers  


Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar

11 Answers   IBM,


why we use informatica in our project?

2 Answers   TCS,


Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

2 Answers   TCS,


suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how

7 Answers   TCS,


to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?

3 Answers   IBM,


select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

5 Answers   Puma,


How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?

1 Answers  


Write the advantages of partitioning a session?

0 Answers  


What is Target Update Override? What is the Use ?

8 Answers   Patni,


Categories