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




Answers were Sorted based on User's Feedback



Answer / abhishek kumar

create one instance of target.
means we take two target(same) his name is different but
table is same.
src->sq->tgt101
|->tgt102
after session run we check
select * from tgt ;
it will will merge the output of tgt101 and 102 and give
result in one tgt table.

Is This Answer Correct ?    6 Yes 2 No

Answer / reddy

Create two target instances,and connect sq to two instances.
Then we will get desired output...

Is This Answer Correct ?    5 Yes 1 No

Answer / chandra

use union TR we get it...
source---->SQ-->UNION-->TRRGET
HEERE
in union TR take 2 input groups and drag source to 2 input
groups and drag union output ports to tatget

Is This Answer Correct ?    5 Yes 1 No




Answer / guest

Connect the target table twice.

Is This Answer Correct ?    6 Yes 3 No

Answer / gyana

pls friends try this..its easy and flexible
--------------------------------------------

SOURCE ---->SOURCE QUALIFIER------->TARGET

IN SQ WRIT THE SQL QUERY
------------------------
SELECT * FROM EMP
UNION ALL
SELECT * FROM EMP WHERE ROWNUM<11


PLS LET ME KNOW IF I AM WRONG

Is This Answer Correct ?    4 Yes 2 No

Answer / kamleshmishra291

user following code in java transformation
for( int i=0;i<2;i++)
{
output_port 1=input port 1;
output_port n=input port n;
generateRow();
}

Is This Answer Correct ?    1 Yes 0 No

Answer / priyank

Take 2 instances of the same source and join them using
Union transformation which acts as the UNION ALL command of
SQL i.e. it allows duplicates too.

Is This Answer Correct ?    0 Yes 0 No

Answer / jz

drop unique constraint in target table and select only
insert in session target properties run the session twice.

Is This Answer Correct ?    2 Yes 3 No

Answer / sateesh a

run the session twice.

before running the session disable the target truncate load
option and disable the distinct option in target.

Is This Answer Correct ?    1 Yes 2 No

Answer / subbu

U can run job two times, and u can put append option in target.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer



More Informatica Interview Questions

How to eliminate 1st and last rows from the source and load the inbetween rows.

5 Answers   Syntel,


What are the different caches used in informatica?

3 Answers   UST,


What is source qualifier?

6 Answers   SDS,


wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35

2 Answers  


can any one explain me about junk dimension

4 Answers  


Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,


What is up date strategy and what are the options for update strategy?

2 Answers  


Can you copy the batches?

3 Answers  


write a query to get maximum salary from the employers table without duplicates....kindly help me

5 Answers   CTS,


Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario

4 Answers   Wipro, TCS,


Differentiate between Load Manager and DTM?

0 Answers  


Enterprise data warehouse your projects phase by phase explain?

0 Answers   Cap Gemini,




Categories