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
In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
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,
How the informatica server increases the session performance through partitioning the source?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Explain lookup transformation in informatica
how can you load data into target table without leading zeor's
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
wt is inline view? when and why we Use ?mail to rayallarv@gmail.com
Can anyone tell me the new features in Informatica 9 Version?
Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.