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

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

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

Question Posted / sunil.knl

6 Answers
11043 Views
HCL, I also Faced
E-Mail Answers

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 / saravana

we can user Normalizer transformation, to convert a row into double row and then load it into target

Is This Answer Correct ?

0 Yes

0 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