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
How can one identify whether mapping is correct or not without connecting session?
how to load dimension table and fact table. plz tell me the steps.
How to update a particular record in target with out running whole workflow?
how you will maintain version?
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details
8 Answers L&T, TCS, UnitedHealth Group, Wipro,
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
Where is the cache stored in informatica?
Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?
Briefly explain the aggregator transformation?
I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out
How do you remove duplicate records in informatica?