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
- 8830 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the popular informatica products?
Difference between Target-based loading and constraint-based loading?
Differentiate between a database and data warehouse?
What is rank transform?
How identifying bottlenecks in various components of informatica and resolving them?
What is the maplet?
What are the differences between joiner transformation and source qualifier transformation?
How many dimensions are there in informatica?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
what is the size of u r source(like file or table)?
What is different between the data warehouse and data mart?
Explain the scenario which compels informatica server to reject files?
How to call shell scripts from informatica?
Enlist some properties of sessions.
What is a joiner transformation?
