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 |
If we are using an aggregator but forget to mention the group by port .what will be the output??
What is the difference between a repository server and a powerhouse?
My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
Briefly describe lookup transformation?
What is a pre-defined event and user-defined event?
What is Index Caches size?
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
what are the settiings that u use to cofigure the joiner transformation?
. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null