There are 3 groups in router transformation in which there
are no conditions mentioned, so what happens if I connect
these groups to the 3 targets? How many records gets into
each target.(suppose if we are getting 10 records from the
source)
- 4 Answers
- 8104 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chakri
10 records into 1 target
10 records into 2 target
10 records into 3 target
| Is This Answer Correct ? | 32 Yes | 0 No |
Answer / venky
3 group conditions are defaultly true
so,each target get 10 recards
totally 30 records
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / raju
Without condtion by default all rows are load to given target/targets.
| Is This Answer Correct ? | 1 Yes | 0 No |
I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?
WAT IS TEXT LOAD?
i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
What are ETL Tools?
Differentiate between mapping parameter and mapping variable?
how to declare array in plsql?
how to use incremental load?
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
What is domain in terms of informatica?
How to enter same record twice in the target table,explain?
Teradata 
