Thread: Duplicating one row into two rows

I have one flatfile by name xyz having one row, and i want to duplicate this one row into two rows in my target table by name xyz without using any transformation or any condition, how can i do this?

NOTE : [This question was asked by Pramod]

just do a straight load...that one row will be inserted into the target table.
Click the update as update checkbox in the target load option and then run the session once again.do reply

How to do if Target is Flat file

Can u please elobarte your question....?

what i said s only for relational targets. for flat files there r some target load options like Loader, but i dunno how to use it. if we cant use in that case i think we shuld use update strategy transformation

Hi ,

If target is flatfile or relational database you can use normalizer (occurs)transformation to make one row into multiple rows.

Regards
cha

hi all

i think we can do this by normalizer rtansformation

First if you want to make duplicate records in target table then u can drag those columns from source qualifier to target table two times, But please make sure tht there should not be any type of unique constraint or primary key constraint on that column at database level otherwise it will give an error.


Reeta