My Source qualifier has empno, sal.
Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET
SAL ------------>TARGET ?
Is this mapping valid or any issues are there if we design
like this?
Answer Posted / abhishek kumar
if second target is instance means name is different but
same target object than mapping is valid.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is a sequence generator transformation?
what is the hint? how to use it to reduce the query processing in program?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Describe an informatica powercenter?
Could you explain what is enterprise data warehouse?
What is status code in informatica?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is source qualifier transformation in informatica?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How do you use reject loader.
What is domain in terms of informatica?