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 / honey
when u apply the procedure given by Mr.Ramesh u will get
alternative records to be stored in the two flatfiles.
Is this what u wanted.
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Mention few power centre client applications with their basic purpose?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Explain the informatica workflow?
can we override a native sql query within informatica? How do we do it?
Write the unconnected lookup syntax and how to return more than one column.
what is the size of your data warehousing?
Explain incremental aggregation in informatica
How to do unit testing in informatica? How to load data in informatica ?
What are the types of presistent cache in look up tr.
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
State the differences between sql override and lookup override?
How you prepared reports for OLAP?
Clarify the utilization of aggregator cache record?
What is option by which we can run all the sessions in a batch simultaneously?