Interested to Buy Any Domain ? << Click Here >> for more details...
how to get flatfile containg 10 records half records one
target another half another target
- 2 Answers
- 5532 Views
- I also Faced
- E-Mail Answers
Answer Posted / gazulas
what if the number 10 changes??
use a sql transfermation and get the record count or use an agg get rec count and pass it into record_count. use seq gen and populate the numbers. then use a router and write condition seq no <= record_count/2 -- target1
default to target 2.
this will work even ur records changes to 100 or 25o or 40000..etc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you use reject loader.
According to his methodology what all you need before you build a datawarehouse
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is the use of an aggregator cache file?
What all join we can perform in LOOKUP transformation?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How to load a Dimension ? and how to load a fact table?
Define sessions in informatica etl?
Mention few advantages of router transformation over filter transformation.
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Tell me about Propagate functions in informatica
What is sequence generator transformation in informatica?
What is a node in Informatica?
tell me 5 session failure in real time how can you solve that in your project?
What is the benefit of session partitioning?
