1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

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 new features of informatica 9.x developer?

535

How to use procedural logic inside infromatica?

642

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1322

How will the document be delivered to me?

621

How to handle decimal places while importing a flatfile into informatica?

727




hi real timers . iam waiting for ur reply regarding ETL TESTING

1814

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2075

Briefly explain the aggregator transformation?

604

draw informatica architecture 8.6 ?

3474

What is target designer and target load order?

662

What do you understand by term role-playing dimension?

587

What is confirmed fact in dataware housing?

5698

What are data-driven sessions?

717

What is complex mapping?

641

Differences between connected and unconnected lookup?

610