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 / bsgsr
send the flat file data into an expression transformation
and create a new pory say xyz and connect nextval mport on
seq_gen to this. then connect expression to router take two
groups. using the nem port created write conditions.
newport<5 in first group ice versa. i believe this would
work
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is a node in Informatica?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What do you understand by term role-playing dimension?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is meant by target load plan?
What is sq transformation?
What is a passive transformation?
What is workflow? What are the components of workflow manager?
Which version configuration tool used in ur project?
In informatics server which files are created during the session rums?
How can we handle two sessions in informatica?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is incremental aggregation?
What is the status code in stored procedure transformation?
Explain how to import oracle sequence into informatica?