What if the source is a flat-file?


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

Post New Answer

More Informatica Interview Questions

Which means the first record should come as last record and last record should come as first record and load into the target file?

0 Answers   Informatica,


i have source in oracle 10g,oracle 8i how will u take the data from two sources

2 Answers   TCS,


source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

6 Answers   CTS, Wipro,


When do you use sql override in a lookup transformation?

0 Answers  


Can i create a lookup table without cache.

7 Answers   iGate,






What are the designer tools for creating transformations?

0 Answers   Informatica,


If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,


List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 Answers  


What is lookup change?

0 Answers  


How do you handle decimal places while importing a flatfile into informatica?

1 Answers  


Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!

2 Answers  


What is a snowflake schema?

0 Answers  


Categories