Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 10 Answers
- 15839 Views
- I also Faced
- E-Mail Answers
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 are the Methods For Creating Reusable Transformations?
Plz can any one say me how to get the informatica certification materials and dumps
Whats there in global repository
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How are indexes created after completing the load process?
How does the aggregator transformation handle null values?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What are the issues you have faced in your project? How did you overcome those issues?
Describe the impact of several join conditions and join order in a joiner transformation?
What can we do to improve the performance of informatica aggregator transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Mention some types of transformation?
Explain direct and indirect flat file loading (source file type) - informatica
