source target
--------- --------
name no sal name no sal max_sal
r 10 1000 r 10 1000 3000
y 20 3000 y 20 3000 3000
Answer Posted / babu
HI James and Simha,
I think u r answer is wrong,please check once.
as per my knowledje,the query is
SELECT E.*,M.MSAL FROM TABLE_NAME E,(SELECT MAX(SAL) MSAL
FROM TABLE_NAME) M;
IF U R SOURCE IS FLATFILE,U NEED TO GO FOR BELOW MAPPING.
SQ----->TRG_TABLE
|
|---->AGG(MAX(SAL))--->TRG_TABLE(MSAL)
IN THE ABOVE DFD IS
1 SOURCE TO TARGET DIRECT MAPPING ALL COLUMNS EXCEPT
MSAL COLUMN.
2.IN THIS DFD FIND THE MAXSAL AND LINK TO IT MSAL IN
THE TARGET TABLE.
IF THERE IS ANY WRONG PLEASE CORRECT ME.
THANKS,
Babu
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What do you mean incremental aggregation?
What all are steps in up gradation of Informatica server?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is the reusable transformation?
What do you mean by enterprise data warehousing?
What are the tasks that can be performed using sq?
How to differentiate between the active and passive transformations?
How do you load alternate records into different tables through mapping flow?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Can we change Dynamic to Static or Persistent cache? If so what happens?
How we can create indexes after completing the loan process?
Briefly explain the aggregator transformation?
How many number of sessions can one group in batches?
What is informatica powercenter repository?