n.sriramk

 Profile Answers by n.sriramk Questions by n.sriramk

• Nov 5th, 2010

 

Simple way is the below one:

Take two paths of same source, use Target Load Order.

Read same data for two times and load the same to target.

* Target must not contain any constraints or primary key, which rejects the data

Experts will this work???

Thanks

Sriram N

IT Analyst

learner_info

 Profile Answers by learner_info 

• Nov 23rd, 2010

 

I guess we can do that task by using a sql statement in source qualifier. If you put this query SELECT * from dept d1 union all select * from dept d2 in source qualifier and link to the target table you will see duplicates.. double the number of records in source table.

javidakram

 Profile Answers by javidakram 

• Dec 4th, 2010

 

Take two instances of target and conect source to target through source qualifier.

kirankumar_ganapuram

 Profile Answers by kirankumar_ganapuram 

• Jan 4th, 2011

 

You can simply take a normalizer transformation and in that transformation you can specify the occurances to 2(by default it is 0). The output will be doubled of the input given records...

Try it.
it works..

Nagaraju Puppala

 Profile Answers by Nagaraju Puppala 

• Feb 9th, 2011

 

You can create the multiple/duplicate sessions in the workflow.

Hope it will be the best approach.


Cheers,
Nagaraju Puppala

Surya_prakash

 Profile Answers by Surya_prakash 

• Feb 10th, 2011

 

Create a mapping with two target instances,form source qualifier copy the ports to two targets.

Harishankar.Iyer

 Profile Answers by Harishankar.Iyer Questions by Harishankar.Iyer

• Feb 18th, 2011

 

You can override the source qualifier query using the below query
select column1, column2 from table A
union all
select column1, column2 from table A

This would result in Duplicates

ch.c.k.raviteja

 Profile Answers by ch.c.k.raviteja Questions by ch.c.k.raviteja

• Feb 21st, 2011

 

Its just simple use the source two times and a target should not contain any
constraints like primary, check etc. and use a union transformation and map the
output of union to target, thats it.
One more way is by using a single source take two targets named same and drag
the source rows for two targets and be shore that target should not contain the
constraints.

Cheers
Teja

Surya

• Aug 5th, 2011

 

take target as two instances

Niranjan

• Apr 7th, 2016

 

Use for loop in Java Transformation

Anupam Kumar

• Apr 8th, 2016

 

Use Router. Create two group and just put TRUE in both

Anil

• Jun 22nd, 2016

 

We can do it by taking expression t/r and 2 instances of same target and connecting from same exp to 2 targets!