Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 10 Answers
- 16392 Views
- I also Faced
- E-Mail Answers
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 are the reusable transformations?
What is the session task and command task?
What is data movement mode in Informatica and difference between them?
What is complex mapping?
How to load data in informatica ?
How to use pmcmd utility command?
How many ways a relational source definition can be updated and what are they?
How do you manage the Parameter files while migrating your data from one environment to another environment?
can anyone suggest best free Talend data integration training online
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Differentiate between sessions and batches?
Is there any way to read the ms excel datas directly into informatica?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
can you please explain me pre session and post session options?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
