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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / amedela chandra sekhar
mapping is valid but we should not do like this.
| Is This Answer Correct ? | 1 Yes | 0 No |
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
Describe an informatica powercenter?
How do you load only null records into target? Explain through mapping flow.
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
Can you use flat files in Mapplets.
Which transformation is needed while using the Cobol sources as source definitions?
checkout and checkin in informatica 8.6
what is lookup ?
In which transformation you cannot drag ports into it?
What does command task mean?
What are the methods for creating reusable transforamtions?
what is the -ve test case in your project.