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)
- 4 Answers
- 8109 Views
- I also Faced
- E-Mail Answers
Answer Posted / raju
Without condtion by default all rows are load to given target/targets.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What do you mean incremental aggregation?
What is workflow monitor?
Enlist the various types of transformations.
What are the tuning techniques you applied during your last project
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is the use of target designer?
Explain the types of transformations?
What is source qualifier transformation in informatica?
What is a shortcut and copy in Informatica and how two are different with each other?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
what is Active lock explain
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
