Interested to Buy Any Domain ? << Click Here >> for more details...
i have flat file it contains 'n' number of records, i need
to send half of the records to one target table and
Remaining half to another target table.
can any tell me procedure.
- 2 Answers
- 7862 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jay
SCR-->SQ-->AGGR-----
| |
| v TRG 1
--------->RTR--> /
/ \
SEQ TRG 2
First get the count of records using Aggr t/r
and use this result in router t/r and have
router condition as SEQ < (Count / 2) for TRG 1
and default for TRG 2
| Is This Answer Correct ? | 11 Yes | 3 No |
Answer / mari ilavarasi
Using router transformation we can send half of the records
in one target and rest of the records will be inserted into
another target based on conditions.
| Is This Answer Correct ? | 6 Yes | 3 No |
In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?
If informatica has its scheduler why using third party scheduler?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
Enlist the differences between database and data warehouse.
When do you use sql override in a lookup transformation?
Discuss the advantages & Disadvantages of star & snowflake schema?
HOW DO YOU PARFORM INCREMENTAL LAOD ?
Can you use one mapping to populate two tables in different schemas
tell me about your project functionality
how you will maintain version?
why do we go for update strategy tr in SCD rather using the session properties?
How to start a workflow using pmcmd command?
Teradata 
