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
Clarify the aggregator change?
Explain what are the different types of transformation available in informatica.
How to join three sources using joiner? Explain though mapping flow.
In which transformation you cannot drag ports into it?
How we can create indexes after completing the load process?
What are Dimensional table?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
is it possible to index the data in cache of lkp transformation ?
Explain pushdown optimization $pushdownconfig parameter - informatica
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How do you update the records with or without using update strategy?
Why filter transformation is an active one?
What is session task and command task?
How many input parameters can exist in an unconnected lookup?
How many ways are there to do 'remove duplicate records in informatica'?