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 / psnadh
Hi,
In the source file if the row count is odd number,then how
can we check the condition to divide the ff into two halves?
If it is even,we can divide the ff into two halves as per
the above solutions.
Please give me reply how to implent that
Thanks in Advance
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain the aggregator transformation?
How you prepared reports for OLAP?
How do you update the records with or without using update strategy?
What is difference between a gateway node and worker node?
What is informatica etl tool?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What does “tail –f” command do and what is its use as an Informatica admin.
Can we override a native sql query within informatica?
How to extract the informatica rejected data?
Can you generate sequence numbers without using the sequence generator transformation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Explain dynamic target flat file name generation in informatica
What is the function of union transformation?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.