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?
Answers were Sorted based on User's Feedback
Answer / guest
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 ? | 3 Yes | 1 No |
Answer / 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 |
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
How to recover the standalone session?
What are limitations of joiner transformation?
difference between shortcut and reusable transformation?
Explain lookup transformation is active in informatica
What are connected or unconnected transformations?
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000
How can we integrate different flat file data in a single mapping and with in a single execution
Explain about HLD and LLD ?
How to recover the standalone session?
Explain what transformation and how many are there in informatica?