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
In which transformation you cannot drag ports into it?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
what is mean by complex business rule ?
What is the meaning of up gradation of repository?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
When do you use sql override in a lookup transformation?
How to use pmcmd utility command?
What is intricate mapping?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
How do you load alternate records into different tables through mapping flow?
can you please explain me pre session and post session options?
What is a snowflake schema?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are the advantages of informatica?
can any one give some examples for pre sql and post sql(Except dropping and creating index).