My Source qualifier has empno, sal. Now my mapping is like
SQ(EMPNO)->AGGR->EXP->TARGET
SAL ------------>TARGET ? means only one source
qualifier has 2 columns like empno, sal. connected to same
target as shown in above mapping.Is this mapping valid or
any issues are there if we design like this?
Answer Posted / sukanta
It will invalid the mapping because one column value is
going through aggregator(Active)transformation.so in this
case you can't by pass other column direct to target.
in sql query
select sal,max(empno) from emp;
it is a wrong statement,but if you put like this
selct sal,max(empno) from emp group by sal;
works fine
I think you get the solution
Regrads
Sukanta
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
As union transformation gives UNION ALL output, how you will get the UNION output?
Is there any way to read the ms excel datas directly into informatica?
How to differentiate between the active and passive transformations?
can we override a native sql query within informatica? Where do we do it?
What is the use of code page?
How to open an older version of an object in the workspace?
What are the components of Informatica? And what is the purpose of each?
How to implement security measures using repository manager?
Explain the use of aggregator cache file?
What are pre and post-session shell commands?
Describe data concatenation?
What does command task mean?
Explain the difference between mapping parameter and mapping variable?
What is Cognos script editor?
How we can create indexes after completing the load process?