If i have source as flat file. how can i store the header and trilor into one target and data into one more target.
|------>target1(header+trailor)
source------
|------>target2(data)

can any one please help me


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

Post New Answer

More Informatica Interview Questions

What are the designer tools for creating tranformations?

1 Answers   Informatica,


write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,


If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?

2 Answers   IBM, WalMart,


How would you join a node to the already existing domain?

0 Answers  


In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?

1 Answers   TCS,






why we use stored procedure transformation?

4 Answers   IBM,


How do we call shell scripts from informatica?

0 Answers  


I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

5 Answers   Patni,


What is the meaning of decode in informatica?

0 Answers  


What is power center repository?

1 Answers  


What is a difference between complete, stop and abort?

0 Answers  


what is the size ur source like(file system or database)? how many record daily come u r banking project?

0 Answers   Cognizant, Flextronics,


Categories