hi all, i have 1 flat file having 10 rows. like:-
id name amt
100 a 100
200 b 200
100 n 300
400 p 3000
100 a 100
600 x 6000
Now i want to load half of this data into one flat file and
remaining in other flat file.like :-
flat file 1
id name amt
100 a 100
200 b 200
100 n 300
----------------------
----------------------
flat file 2
id name amt
400 p 3000
100 a 100
600 x 6000
Plz reply me ASAP.
Answer Posted / honey
when u apply the procedure given by Mr.Ramesh u will get
alternative records to be stored in the two flatfiles.
Is this what u wanted.
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Informatica Checkpoints
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
explan ur project architecture?
Define sessions in informatica etl?
What differs when we choose the sorted input for aggregator transformation?
How do you load alternate records into different tables through mapping flow?
Define joiner transformation?
What are the restrictions of union transformation?
What is a passive transformation?
How to generate sequence numbers using expression transformation?
What is workflow monitor?
How can you validate all mappings in the repository simultaneously?
Enlist some properties of sessions.
Explain your project of banking domian.