Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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?

Question Posted / manojdubba

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 is source qualifier transformation?

1 Answers  

What is different between the data warehouse and data mart?

0 Answers  

What is a configuration management?

1 Answers  

Quickly characterize reusable change?

0 Answers  

in what type of scenario bulk loading and normal loading we use?

2 Answers   Cognizant, Wipro,

How can we get multiple output values using an unconnected lookup transformation?

2 Answers   TCS,

yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

2 Answers   iGate,

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

4 Answers   Magna Infotech,

Can we update a target table (without primarykey) by using update strategy transformation?

4 Answers   TCS,

what is curr val use for in sequence generator?

2 Answers   Emphasis,

A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?

4 Answers  

what are testing in a mapping level please give brif eplanation

1 Answers   CTS,

For more Informatica Interview Questions Click Here
Categories