NOT GOT APPROPRIATE RESULT BY GOING THROUGH THE SOLUTION GIVEN BY Shashank

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 / indra

10 Answers
15841 Views
I also Faced
E-Mail Answers

Answer Posted / indra

NOT GOT APPROPRIATE RESULT BY GOING THROUGH THE SOLUTION
GIVEN BY Shashank....

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2025

What is a code page?

1119

Explain the different dimensions.

917

What is an active transformation?

1038

What is Session and Batches?

1042

What are the features of complex mapping?

1100

Name the different lookup cache(s)?

1161

How to partition the Session?

1045

Enterprise data warehouse your projects phase by phase explain?

1857

What are the conditions needed to improve the performance of informatica aggregator transformation?

1038

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

918

Describe the impact of several join conditions and join order in a joiner transformation?

1010

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2255

what is SDLC way of code development?

1971

Explain constraint based loading in informatica

1041