Answer / sreekanth

select * from table_name
union all
select * from table_name;

Answer / james

Take two target instances in the mappings
This will load 20 records in the 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

Answer / prabu

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

Answer / saravana

we can user Normalizer transformation, to convert a row into double row and then load it into 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..

Different types of Power center errors?

1 Answers   Cinterco, IBM,

If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,

what is the difference between copy object import objects using repositery manager which one is best

1 Answers   TCS,

we have to use order by,where,having we to implement sql query

1 Answers   Satyam,

Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?

1 Answers  

i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?

9 Answers   Cap Gemini,

What are the challenges you have faced in your project?

1 Answers   Cognizant, Infosys,

What is polling in informatica ?

1 Answers   TCS,

How to load time dimension?

1 Answers   Ford,

What is the default join that source qualifier provides?

3 Answers   Informatica,

What is the fact table?

0 Answers  

What all join we can perform in LOOKUP transformation?

0 Answers