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 / sai.masarapu.chowdary

using normalizer transformation we can do as follows:

from source qualifier give the column to the normalizer tr
then put occur for 4 times.

put that occurs to the target. thats it..

Is This Answer Correct ?    18 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we override a native sql query within informatica?

1092


What is the advantage of informatica?

1125


How does a rank transform differ from aggregator transform functions max and min?

1263


What is the Process to creating lookup transformation in informatica

1091


What is the function of union transformation?

1204


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

2048


What is a sequence generator transformation?

1075


How do you promote a non-reusable transformation to reusable transformation?

1180


What's the layout of parameter file (what does a parameter file contain?)?

2439


How to load the data from a flat file into the target where the source flat file name changes daily?

1103


Explain sql transformation in script mode examples in informatica

1211


What is the use of an aggregator cache file?

1249


How to elaborate powercenter integration service?

1175


How can one identify whether mapping is correct or not without connecting session?

1498


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1141