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 : [I][This question was asked by Pramod][/I]
Re: Duplicating one row into two rows
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
Re: Duplicating one row into two rows
How to do if Target is Flat file
Re: Duplicating one row into two rows
Can u please elobarte your question....?
Re: Duplicating one row into two rows
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
Re: Duplicating one row into two rows
Hi ,
If target is flatfile or relational database you can use normalizer (occurs)transformation to make one row into multiple rows.
Regards
cha
Re: Duplicating one row into two rows
hi all
i think we can do this by normalizer rtansformation
Re: Duplicating one row into two rows
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