From where you extract the data, how you did it into
informatica? explain....



From where you extract the data, how you did it into informatica? explain......

Answer / davankumar

Its imp ??? every company should ask these ???.If source is
relation tables source data is relational (ie means oracle
9i/10g)
But source is flat that can in unix server(client can give
path details ).in informatica we have to create the
sturuture of table and give that path address in the
session property tab.

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Informatica Interview Questions

Can you use the maping parameters or variables created in one maping into any other reusable transformation?

1 Answers  


What is InformaticaPowerCenter?

0 Answers   Informatica,


What are data-driven sessions?

0 Answers  


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

0 Answers   IBM,


What is router transformation

4 Answers   CSC,






What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

3 Answers  


How do you migrate data from one environment to another?

0 Answers  


State the differences between sql override and lookup override?

0 Answers  


How to do Integration testing in Informatica?

5 Answers   Intelligroup,


my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times

3 Answers   Satyam,


Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti

1 Answers   Accenture, Patni,


What is the format of informatica objects in a repository?

0 Answers  


Categories