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 |
when we use dynamic lookup,if condition matches what will be the o/p?
Why union transformation is an active transformation?
tell me about your project functionality
Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti
What is the scenario which compels informatica server to reject files?
Define Pmrep command?
i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/
How are parameters defined in informatica?
What if the source is a flat-file?
Briefly define reusable transformation?
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?