solution1:- use rank transformation, divide into two quartiles and pass t

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

10 Answers
16393 Views
I also Faced
E-Mail Answers

Answer Posted / sajjan

solution1:- use rank transformation, divide into two
quartiles and pass them to different targets

Is This Answer Correct ?

0 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain sessions and how many types of sessions are there?

1011

How do you set a varible in incremental aggregation

1891

Differentiate between sessions and batches?

1019

Explain the aggregator transformation?

1167

What do you mean by channel change?

1048

What is informatica? Why do we need it?

1102

what is Active lock explain

2800

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2137

What are active transformations.

1657

What is update strategy transform?

1106

how to create user defined function (udf) in informatica

1308

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1110

Explain the difference between a data warehouse and a data mart?

1057

How can we delete duplicate rows from flat files?

1223

What is complex mapping?

1122