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)
Answers were Sorted based on User's Feedback
Answer / chakri
10 records into 1 target
10 records into 2 target
10 records into 3 target
| Is This Answer Correct ? | 32 Yes | 0 No |
Answer / venky
3 group conditions are defaultly true
so,each target get 10 recards
totally 30 records
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / raju
Without condtion by default all rows are load to given target/targets.
| Is This Answer Correct ? | 1 Yes | 0 No |
in static and dynamic which one is better
How can we use mapping variables in informatica?
how can we load starting with 11th record of a table from source to target
Difference between Target-based loading and constraint-based loading?
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how
can any one explain me about junk dimension
what is work of PUSH DOWN option
how do u tune queries?
What is the function of look up transformation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
how to load duplicate row in a target
In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?