Rajeev Das

• Sep 1st, 2011

 

Try these below:

1. you can use router transformation and load data into two target.
2. use query in source qualifier insert into select * from .

please let me know if this works!!

Thanks,

sridkaretl

 Profile Answers by sridkaretl 

• Oct 21st, 2011

 

hi,

we cannot use router transformation because router transformation is condition dependent and data is stored into multiple target. For using push-down optimization(Source-Qualifier) data is stored only in one target and if you try to insert again it will create duplicates or copy of the existing fields. instead i suggest to use constraint based loading which is dependent upon primary key and foreign key.

Regards,
Karthik

rangarao.dwh

 Profile Answers by rangarao.dwh 

• Jan 9th, 2012

 

For this Question I can provide four answers
1. By using union Transformation
2. Connect target two times to two source
3. By using Target load plan
4. By using Java transformation
Note: All of the methods works only when the target having no Primary key or Unique Key.