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)
Answer Posted / chakri
10 records into 1 target
10 records into 2 target
10 records into 3 target
| Is This Answer Correct ? | 32 Yes | 0 No |
Post New Answer View All Answers
Explain target update override in informatica
How many ways are there to do 'remove duplicate records in informatica'?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How big was your fact table
How can we use mapping variables in informatica? Where do we use them?
What is decode in static cache?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
State the limitations where we cannot use joiner in the mapping pipeline?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the designer tools for creating transformations?
What is the use of an aggregator cache file?
What are multi-group transformations?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How do you update the records with or without using update strategy?