select * from table_name union all select * from table

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

Question Posted / sreekanth

Answer Posted / sreekanth

select * from table_name
union all
select * from table_name;

Is This Answer Correct ?

13 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the uses of etl tools?

1175

What is meant by lookup transformation? Explain the types of lookup transformation?

1019

How to update or delete the rows in a target, which do not have key fields?

1222

What are the issues you have faced in your project? How did you overcome those issues?

2412

Under which circumstances, informatica server creates reject files?

1139

can we override a native sql query within informatica? Where do we do it?

1166

What is intricate mapping?

1311

How do you load only null records into target?

1252

What is mapplet in informatica?

1125

What is primary and backup node?

1174

Why filter transformation is an active one?

1033

What if the source is a flat-file?

1168

What does command task mean?

1216

Sequence generator, when you move from develoment to production how will you reset

2123

list out all the transformations which use cache?

1240