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

difference between repository database and repository service?

1161

What is source qualifier transformation in informatica?

1019

How do you load unique records into one target table and duplicate records into a different target table?

1272

What is dimensional table? Explain the different dimensions.

1177

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1066

What is a joiner transformation?

1002

Which files are created during the session rums by informatics server?

1190

Explain lookup transformation in informatica

1082

How can informatica be used for an organization?

1226

Target increases every day even though no new record was inserted

1591

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2135

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5804

Whats there in global repository

1700

What are the different types of transformation available in informatica.

1109

What is the function of union transformation?

1144