how to get flatfile containg 10 records half records one
target another half another target
- 2 Answers
- 4948 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mahipal reddy
first create a sequence to those 10 records n using filter
or router transformation filter first 5 columns n load into
target similarly remianing 5 records.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
How does a rank transform differ from aggregator transform functions max and min?
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it
How to Join Tables my Source is having 15 table target is one?
Types of error logs in Informatica?
what is the difference between Informatica 7.1 and Abinitio?
How to eliminate duplicates from flat file..what is the procedure
What are the performance considerations when working with aggregator transformation?
what is data driven?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
How do you convert single row from source into three rows into target?
what r the values tht r passed between informatics server and stored procedure?
Teradata 
