if i am having 10 records in source, i want 20 records in
target...how will you do it
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
Difference between Data and Index Caches?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is the difference between a repository server and a powerhouse?
Explain sql transformation in script mode examples in informatica
I have a flat file, want to reverse the contents of the flat file
What are the different types of repositories created using informatica?
how we can load rejected record's at run time?(not through bad files)
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How we can use union transformation?
What is workflow manager?
Explain the different dimensions.
hi real timers . iam waiting for ur reply regarding ETL TESTING
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
what is the hint? how to use it to reduce the query processing in program?
Design time, run time. If you don't create parameter what will happen