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
What are batches?
In warehouses how many schemas are there?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is the benefit of partitioning a session?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Can you use flat files in Mapplets.
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Explain pmcmd command usage in informatica
What is source qualifier transformation in informatica?
What is intricate mapping?
what is the complex transformation you used in informatica
What is rank transformation?
define galaxy repository in informatica
What is the function of look up transformation?