Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


if soource is having 10 records how will u insert 20
records to target

Answers were Sorted based on User's Feedback



if soource is having 10 records how will u insert 20 records to target..

Answer / sreekanth

select * from table_name
union all
select * from table_name;

Is This Answer Correct ?    13 Yes 0 No

if soource is having 10 records how will u insert 20 records to target..

Answer / james

Take two target instances in the mappings
This will load 20 records in the target

Is This Answer Correct ?    2 Yes 0 No

if soource is having 10 records how will u insert 20 records to target..

Answer / priyank

Take 2 instances of source and join them unsin UNION
transformation(provided the target structure is same as the
source structure).

SQ1 --> UNION --> EXP --> Target
SQ2

Is This Answer Correct ?    2 Yes 0 No

if soource is having 10 records how will u insert 20 records to target..

Answer / prabu

hi sanjay,
me too think the same way to thought.. are u sure this is
the right way to do.

Is This Answer Correct ?    1 Yes 1 No

if soource is having 10 records how will u insert 20 records to target..

Answer / sanjay

keep the "Truncate Target Table Option" uncheck in the
session and run the workflow two times..
You can get the 20 records..

Is This Answer Correct ?    4 Yes 7 No

Post New Answer



More Informatica Interview Questions

I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....

4 Answers   Patni,


What is a code page?

0 Answers  


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

0 Answers   Informatica,


i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?

1 Answers   Mind Tree,


What are the types of maping in Getting Started Wizard?

1 Answers  






What the difference is between a database, a data warehouse and a data mart?

0 Answers  


what is mapping performence?

2 Answers   Cap Gemini,


If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values

6 Answers   TCS,


What is substr in informatica?

0 Answers  


what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,


Do you have to change the reject file b4 using reject loader utility.

1 Answers  


How to create a non-reusable instance of reusable transformations?

0 Answers   Informatica,






Categories