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
- 16855 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 you know about transaction control transformation?
What is target load order?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is a code page?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
How many numbers of sessions can one group in batches?
Explain about cumulative Sum or moving sum?
Is stop and abort are same in informatica?
What is a grid in Informatica?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Explain the features of connected and unconnected lookup.
How do you set a varible in incremental aggregation
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Define mapping and session?
