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
- 16262 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
How to generate or load values in to the target table based on a column value using informatica etl tool.
What are junk dimensions?
What is a sequence generator transformation?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What do you understand by a term domain?
Which version configuration tool used in ur project?
What are the tasks that can be performed using sq?
explain one complex mapping with logic? sales project?
How an expression transformation differs from aggregator transformation?
How do you migrate data from one environment to another?
What is the sql query overwrite in source qualifier in informatica
What are the different types of repositories created using informatica?
what is Active lock explain
How to load the data from a flat file into the target where the source flat file name changes daily?
What is aggregator transformation in informatica?
