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
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is the difference between a repository server and a powerhouse?
can we override a native sql query within informatica? Where do we do it?
What is confirmed fact in dataware housing?
Explain constraint based loading in informatica
explain abt ur project architecture?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is workflow manager?
Define update strategy?
Explain what is informatica metadata and where is it stored?
Is it possible to revert a global repository to local one and why?
Which development components of informatica have the highest usage?
What are the different clients of powercenter?
How do you take back up of repository?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??