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
- 5496 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
What you know about transaction control transformation?
what is the hint? how to use it to reduce the query processing in program?
What are the data movement modes in informatica?
What is source qualifier transformation in informatica?
How to generate or load values in to the target table based on a column value using informatica etl tool.
How do you convert single row from source into three rows into target?
Explain scd type 3 through mapping.
What do you mean by channel change?
What are the different types of olap? Give an example?
can you please explain me pre session and post session options?
What is the cumulative sum and moving sum?
What is a joiner transformation and why it is an active one?
hi real timers . iam waiting for ur reply regarding ETL TESTING
waht type of interface is used for testing the data in informatica
What is xml source qualifier transformation in informatica?
