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 / bala ramesh
in this logic , frist take one sequene genrator
transformation ,pass next value to expression
transformation and also pass id,name,and amt.
in this transformation and also create one output port
(temp).it is decimat type and write codition like
(iif(NEXTVAL %2=0,0,1)) , after take one router
transformation ,pass these ports (id,name,amt and
temp) .then create two group ,one is temp=0 and another one
is temp=1.after pass first group to one flat file ,second
group to second flat file.
Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
What is a connected transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is domain in terms of informatica?
How to call shell scripts from informatica?
What's the layout of parameter file (what does a parameter file contain?)?
How might you approve all mappings in the archive all the while?
What is meant by lookup transformation? Explain the types of lookup transformation?
Explain the types of lookup transformation?
Describe an informatica powercenter?
generate date / time dimension in informatica
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Write the unconnected lookup syntax?
What are Dimensional table?
What does update strategy mean, and what are the different option of it?