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.
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
Define mapping and session?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Define pmcmd command?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What are the new features of informatica 9.x developer?
What do mean by local and global repository?
Where can we find the throughput option in informatica?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What are the new features of informatica 9.x in developer level?
What are the tuning techniques you applied during your last project
Explain sessions. Explain how batches are used to combine executions?
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.
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How we can use union transformation?