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 |
we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?
2 Answers Patni, Tech Mahindra,
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani
my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?
how to through logic of informatica using the push down optimization into oracle.
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
what is session override?
What is informatica? What exactly are the practical uses in real world
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is staging area?
How will you check the bottle necks in informatica? From where do you start checking?
What are data-driven sessions?
What is the use of an aggregator cache file?