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 |
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
In which scenario did u used Mapping variable?
EXL informatica Questions
Can any one explain or sujjest some sites for scd mappings.Thank you
Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?
What are the new features of Power Center 5.0?
What do you mean by filter transformation?
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
What are the tasks that Loadmanger process will do?
Can u generate reports in Informatica?
What is meant by target load plan?
Define filter transformation?