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...


if i am having 10 records in source, i want 20 records in
target...how will you do it

Answers were Sorted based on User's Feedback



if i am having 10 records in source, i want 20 records in target...how will you do it..

Answer / srinivas

if source is table you can use sql override
select * from emp
union
select * from emp
and if source is not a table run the session twice

Is This Answer Correct ?    0 Yes 4 No

if i am having 10 records in source, i want 20 records in target...how will you do it..

Answer / sbvp

RUN THAT MAPPING TWICE U WILL GET 20 RECORDS

Is This Answer Correct ?    2 Yes 8 No

if i am having 10 records in source, i want 20 records in target...how will you do it..

Answer / guduri

to get dis dont enable the property called truncate target
table option in session properties

Is This Answer Correct ?    0 Yes 6 No

Post New Answer

More Informatica Interview Questions

how can we load first and last record from a flat file source to target?

7 Answers   Infosys, ITC Infotech,


how we do performence tuning in informatica

3 Answers  


Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?

2 Answers  


How to display null values on a target & non-null values on a target?

3 Answers  


SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?

1 Answers   IBM,


What are the basic needs to join two sources in a source qualifier?

3 Answers  


What is the difference between Active and Passive transformation?

0 Answers   Informatica,


How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

3 Answers   Logica CMG,


Explain how to import oracle sequence into informatica?

0 Answers  


What is a taget load order?

2 Answers   IBM,


how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)

3 Answers   Cognizant, HP, TCS,


What is the commit type if you have a transaction control transformation in the mapping?

0 Answers   Informatica,


Categories