Interested to Buy Any Domain ? << Click Here >> for more details...
Hi,
In Router transformation I created two groups .
One is Passthrough=> True
Second one is CorrectId’s => Invest>50000
Here I have one doubt. Can’t I treat default group as
Passthrough group (fist group) . Is there any difference
between default group and Passthrough group in this
scenario?
Let me know if you want more information about this
scenario.
Advance thanks.
- 3 Answers
- 9863 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srinivas
yes there is a diff in this scenario.
the first group (pass through) will pass all the records with all invests
second group will pass invests > 50000 and
finally if u want to use the default group instead of first group then,
default group will pass all the records with
invest <= 50000
correct me if i am wrong
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / priyank
Hi,
In Router, we can create multiple groups based on the
different filter conditions.Default group as the name
suggests gets created by Default.When source data pass
through the router, it sends records to the different
targets based on the filter condition and if still there
are some rows which does not satisfy any of the group
conditions, then those records go through the Default group.
So in your case, there would be no records, which go
through the default group as all the records pass through
the "Passthrough" group.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / c manojkumar
Thanks Srinivas and priyank for your inputs.
Yes I got it now. I can't use default group insted of
passthrough. since passthrough group will have all the
records where as defalult group will have only few i.e. the
records which did not meet any of the group conditions.
| Is This Answer Correct ? | 0 Yes | 0 No |
in which situations do u go for snowflake schema ?
What is the difference between Bulk Load and Normal Load
What are the different components of powercenter?
how much memory (size) occupied by a session at runtime
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is a look up function? What is default transformation for the look up function?
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
How do you join more than 3 flat files in informatica?
Which is better performance wise database or file?How?
What is exclusive and normal mode for repository services?
what is the use of Data Mart?
If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.
Teradata 
