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
- 7843 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 EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
How can we eliminate duplicate rows from flatfile,explain?
what are the output files that the informatica server creats during running a session?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
what is the size of u r source(like file or table)?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What are the conditions needed to improve the performance of informatica aggregator transformation?
How does a rank transform differ from aggregator transform functions max and min?
My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow
How many ways you create ports?
Teradata 
