source target
--------- --------
name no sal name no sal max_sal
r 10 1000 r 10 1000 3000
y 20 3000 y 20 3000 3000
- 7 Answers
- 11349 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
What is deployment group?
What is intricate mapping?
How might you approve all mappings in the archive all the while?
What is a difference between complete, stop and abort?
Explain constraint based loading in informatica
Explain direct and indirect flat file loading (source file type) - informatica
How to load a Dimension ? and how to load a fact table?
How many types of sessions are there in informatica.please explain them?
What are the different types of transformation available in informatica.
What is the need for an etl tool?
explain about unit testing? in real time?
In warehouses how many schemas are there?
where to store informatica rejected data? How to extract the informatica rejected data?
What is complex mapping?
What is depict expression change?
