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..

What is sql query override? When did u use sql query override?

1 Answers   TCS,

Enterprise data warehouse your projects phase by phase explain?

0 Answers   Cap Gemini,

which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?

3 Answers   Wipro,

How can we store previous session logs?

0 Answers  

In Which scenario did u used Incremental loading?

2 Answers  

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?

3 Answers   CTS, Wipro,

In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process

2 Answers   Wipro,

what is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,

write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80

3 Answers   iGate,

Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?

2 Answers   CTS,

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,

What r the type of indexes u generally used in informatica?

2 Answers   Keane India Ltd,