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
15852 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

Difference between Target-based loading and constraint-based loading?

950

What are the databases that informatica can connect to windows?

1003

Explain the different dimensions.

917

Explain pushdown optimization $pushdownconfig parameter - informatica

1083

How to use pmcmd utility command?

975

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1870

What do think which one is the better joiner or look up?

1147

What is informatica worklet?

991

What are the popular informatica products?

962

What is the meaning of decode in informatica?

1077

What is source qualifier transformation in informatica?

950

Why do you use Mapping Parameter and mapping variable?

1682

What are mapplets?

1218

How to elaborate powercenter integration service?

1075

What is sq transformation?

1082