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
Define Pmrep command?
what is INFORMATICA TESTING process
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Define the various join types of joiner transformation?
What is the need of an ETL tool?
How to update or delete the rows in a target, which do not have key fields?
pmscmd startworkflow -sv
How you prepared reports for OLAP?
How do you convert single row from source into three rows into target?
What are the prerequisite tasks to achieve the session partition?
In informatics server which files are created during the session rums?
Why filter transformation is an active one?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
write a query to retrieve the latest records from the table sorted by version(scd)
Explain the mapping variable usage example in informatica