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
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 / eswar
All the 3 targets get 10 recrods each
|Is This Answer Correct ?||8 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 the records doesnt satisfy the filter condition where will it go?
What is Session and Batches?
What is blocking transformation?
performance wise which one is better in joiner and lookup transformation
What is a transaction control transformation?
Can we create multiple integration service on single repository?
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
What is rank index in rank transformation?
What could be the possible resons of locks by user?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.
What are the ETL tools available in DWH?