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
- 9817 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 |
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Explain the scenario which compels informatica server to reject files?
What is the status code in stored procedure transformation?
How to start a workflow using pmcmd command?
What is the difference Between Mapping parameter and variable
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Describe the impact of several join conditions and join order in a joiner transformation?
In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?
what is scd?
how to create a sample mapping for dynamic lookup transformation
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
tell me 5 session failure in real time how can you solve that in your project?
Teradata 
