Thanks to all, But i want to store first half data in 1 table and anothe

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.

Question Posted / romi

10 Answers
16840 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

what is index?how it can work in informatica

2083

Briefly describe lookup transformation?

1097

generate date / time dimension in informatica

1164

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2090

Describe an informatica powercenter?

1194

What is enterprise data warehousing?

1107

What is option by which we can run all the sessions in a batch simultaneously?

1192

How many input parameters can exist in an unconnected lookup?

1604

Explain how to import oracle sequence into informatica?

1071

What is incremental aggregation?

1137

How can repository reports be accessed without sql or other transformations?

1268

Briefly define reusable transformation?

1184

What is the difference between informatics 7x and 8x and what is latest version?

1138

can anyone suggest best free Talend data integration training online

1745

Explain in detail scd type 2 through mapping.

1092