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 to load rows into fact table in data warehouse
What are the different components of powercenter?
What is powercenter on grid?
How to call shell scripts from informatica?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is intricate mapping?
What is the maplet?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
How can you increase the performance in joiner transformation?
draw informatica architecture 8.6 ?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What are data-driven sessions?
Explain what is informatica metadata and where is it stored?
Explain Dataware house architecture .how data flow from intial to end?
How can we delete duplicate rows from flat files?