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.
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
What is the difference between source qualifier transformations source filter to filter transformation?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is informatica etl tool?
What could be the possible resons of locks by user?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What are the components of Informatica? And what is the purpose of each?
expain about the tune parameters?
Is it possible to define a single node as a Gateway node as well as worker node?
What are the components of the workflow manager?
What are the types of data warehouses?
What is domain in terms of informatica?
Is stop and abort are same in informatica?
Explain what are the different versions of informatica?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is the Process to creating lookup transformation in informatica