if i am having 10 records in source, i want 20 records in
target...how will you do it
- 13 Answers
- 15078 Views
- BirlaSoft, IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are the tasks that source qualifier perform?
have u done any performance tuning? how u ll do?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Explain lookup transformation source types in informatica
What does update strategy mean, and what are the different option of it?
How do you load first and last records into target table?
my source is junk data how will u remove that junk data by using unix please any one replay me
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What does role playing dimension mean?
What are the tasks that can be performed using sq?
How many number of sessions can one group in batches?
What is the function of union transformation?
what is the Default Source Option For Update Strategy Transformation?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
