Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Hi,

I have one scenario.. i want to insert 4 times (Duplicate)
a row in the target. Please help me .

source row: abcabc


Tgt table:

abcabc
abcabc
abcabc
abcabc

Answer Posted / paramaguru

source qualifier---field1
connect field1 to all the 4 field in the normalizer.
normalizer: In the normalizer maker occurs as 4
it will creat automatically
NEWfield1
NEWfield2
NEWfield3
NEWfield4
NEWFIELD
GK_NEWFIELD
GCID_NEWFIELD

target:OUTPUT
connect newfield to the target output

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the mapping parameters and mapping variables?

1211


How do you load unique records into one target table and duplicate records into a different target table?

1275


Design time, run time. If you don't create parameter what will happen

1843


Explain what are the different versions of informatica?

1110


How do you load alternate records into different tables through mapping flow?

1882


Which transformation should we use to normalise the COBOL and relational sources?

1224


What is the difference between a repository server and a powerhouse?

1525


How you can differentiate between connected lookup and unconnected lookup?

1069


How can we remove the duplicates from flat file source?

1049


What is a node in Informatica?

1049


Differentiate between sessions and batches?

1027


What are the new features of informatica 9.x at the developer level?

1053


How many ways are there to do 'remove duplicate records in informatica'?

1026


During the running session, output files are created by informatica server. Enlist few of them.

993


How many types of sessions are there in informatica.please explain them?

1181