Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

Duplicating one row into two rows

This is a discussion on Duplicating one row into two rows within the Data Warehousing forums, part of the Databases category; 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 ...

Geeks Talk > Databases > Data Warehousing Duplicating one row into two rows

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   01-11-2007

JobHelper Expert Member   Join Date: Oct 2006 Posts: 690 Thanks: 0 Thanked 49 Times in 41 Posts

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]

Sponsored Links

#2 (permalink)   02-03-2007

sat.inn Junior Member   Join Date: Feb 2007 Location: india Posts: 7 Thanks: 0 Thanked 1 Time in 1 Post

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

#3 (permalink)   02-03-2007

chakravarthy_info Junior Member   Join Date: Jan 2007 Location: India Posts: 5 Thanks: 0 Thanked 0 Times in 0 Posts

Re: Duplicating one row into two rows How to do if Target is Flat file

#4 (permalink)   02-05-2007

vmandviya Junior Member   Join Date: Feb 2007 Location: India Posts: 2 Thanks: 1 Thanked 0 Times in 0 Posts

Re: Duplicating one row into two rows Can u please elobarte your question....?

#5 (permalink)   02-05-2007

sat.inn Junior Member   Join Date: Feb 2007 Location: india Posts: 7 Thanks: 0 Thanked 1 Time in 1 Post

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

#6 (permalink)   02-09-2007

chakravarthy_info Junior Member   Join Date: Jan 2007 Location: India Posts: 5 Thanks: 0 Thanked 0 Times in 0 Posts

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

#7 (permalink)   07-11-2007

sharada y Junior Member   Join Date: May 2007 Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts

Re: Duplicating one row into two rows hi all i think we can do this by normalizer rtansformation

#8 (permalink)   07-11-2007

reetasharma108 Contributing Member   Join Date: Apr 2007 Location: bangalore Posts: 46 Thanks: 0 Thanked 9 Times in 9 Posts

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

The Following User Says Thank You to reetasharma108 For This Useful Post:

N SRIRAM K

Geeks Talk > Databases > Data Warehousing

« How to work with Merge Stage? | I am having one dimension »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Display n-1 rows from a table	dbtester	SQL Server	3	02-07-2008 08:11 AM
Geting data from odd rows of an excel sheet,	JobHelper	WinRunner	2	10-18-2007 07:17 AM
Rejected rows	JobHelper	Data Warehousing	3	05-14-2007 06:17 AM

All times are GMT -4. The time now is 02:45 PM.