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.
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 / chandra
use union TR we get it...
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
SELECT * FROM EMP WHERE ROWNUM<11
PLS LET ME KNOW IF I AM WRONG
|Is This Answer Correct ?||4 Yes||2 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|
How to eliminate 1st and last rows from the source and load the inbetween rows.
What are the different caches used in informatica?
What is source qualifier?
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
can any one explain me about junk dimension
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
What is up date strategy and what are the options for update strategy?
Can you copy the batches?
write a query to get maximum salary from the employers table without duplicates....kindly help me
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
Differentiate between Load Manager and DTM?
Enterprise data warehouse your projects phase by phase explain?