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)
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 |
Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that
what is the main advantage of unconnected lookup
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
difference between stop and abort
What is the format of informatica objects in a repository?
Define pmcmd command?
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
How to handle changing source file counts in a mapping?
What are active and passive transformations?
what is work of PUSH DOWN option
what is shortcut in informatica? difference between shortcut,reusable object?
Can you copy the batches?