if source is table you can use sql override select * from emp union sel

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

Question Posted / srinivas

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

How is union transformation utilized?

567

The question was on time stamp. what is the difference between HH and HH24 when to use when.

1552

What is informatica?

678

What is workflow monitor?

593

how we can load rejected record's at run time?(not through bad files)

1908

Is there any target staging area in informatica not staging area

2122

What is complex mapping?

635

What are mapplets? How is it different from a Reusable Transformation?

624

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

730

Differentiate between a repository server and a powerhouse?

575

What is a difference between complete, stop and abort?

640

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1578

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

597

What is informatica etl tool?

550

Why sorter is an active transformation?

746