how to design mapping half of source table records into one
target and remaining half into another target

Answer Posted / ravi

by using router transformation

Is This Answer Correct ?    2 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Cognos script editor?

3867


How can we delete duplicate rows from flat files?

849


How do you load first and last records into target table?

784


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1751


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1540






What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7801


Can we change Dynamic to Static or Persistent cache? If so what happens?

1811


what are 3 tech challenges/ common issues you face?

1980


What could be the possible resons of locks by user?

747


Difference between Data and Index Caches?

766


Describe the impact of several join conditions and join order in a joiner transformation?

735


what is unit testing?tell me proceedure

1880


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5141


What do you mean by worklet?

721


What is the difference between informatics 7x and 8x and what is latest version?

651