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



My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET ..

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

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET ..

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

Post New Answer

More Informatica Interview Questions

What are slowly changing dimensions?

5 Answers   Informatica, Verinon Technology Solutions,


How to recover the standalone session?

2 Answers  


What are limitations of joiner transformation?

2 Answers   Exilant, TCS,


difference between shortcut and reusable transformation?

2 Answers  


Explain lookup transformation is active in informatica

0 Answers   Informatica,






What are connected or unconnected transformations?

0 Answers   Informatica,


how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

2 Answers   TCS,


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

7 Answers  


How can we integrate different flat file data in a single mapping and with in a single execution

1 Answers  


Explain about HLD and LLD ?

16 Answers   Accenture,


How to recover the standalone session?

2 Answers  


Explain what transformation and how many are there in informatica?

0 Answers  


Categories