Question { Deloitte, 45699 }

Can we have a Mapping without a Source Qualifier?

Answer

In case of XML files, it's called as XML source qualifier.
So we can't have mapping without SQ.

Question { Wipro, 6246 }

what is work of PUSH DOWN option

Answer

The Pushdown Optimization Option improves performance by
enabling processing to be “pushed down” to a
relational database, maximizing fl exibility, minimizing
unnecessary data movement, and providing the optimal
performance for both data-intensive and process-intensive
transformations.

Question { 3737 }

Hello,

I have the below table:

CityID CityName CostOfLiving
1 Mumbai 5000
1 Bangalore 4500
1 Chennai 4800
2 Vapi 6000
3 New Delhi 8000

I am passing the rows of the above table through the
aggregator transformation in Informatica

What happens in the following conditions:
1) I specify no group-by ports?
2) I specify a group-by on CityID without making any
separate post for aggregation? Which city and costofliving
will this eventually take for CityID=1?
3) Rest being same as point 2,I take the sum of cost of
living.Which city will be returned for ID=1?

Thanks for your help!

Answer

Aggr transformation returns last row of each block or each
group. So here are the ans
Output of Case 1)
3 New Delhi 8000

Output of Case 2)
1 Chennai 4800

Output of Case 3)
1 Chennai 14300