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 / romi
Thanks to all,
But i want to store first half data in 1 table and another
half in another table. and with procedure i m getting
alternative data.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the meaning of decode in informatica?
What is meant by LDAP users?
What are the different types of transformation available in informatica.
can anyone explain me about retail domain project in informatica?
How can we use mapping variables in informatica? Where do we use them?
EXL informatica Questions
Explain the aggregator transformation?
Is there any target staging area in informatica not staging area
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
wf dont have integration severances how you can run?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What do you mean incremental aggregation?
tell me about your project functionality
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is the function of look up transformation?