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

What will be the approach?

929

---

Plz can any one say me how to get the informatica certification materials and dumps

1999

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1195

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1792

---

what is index?how it can work in informatica

1980

---

without table how to come first record only in oracle?

2205

---

What are the components of the workflow manager?

1079

---

What is lookup transformation?

1002

---

Write the advantages of partitioning a session?

1203

---

Could you explain what is enterprise data warehouse?

1047

---

what is the -ve test case in your project.

2329

---

What is depict expression change?

1028

---

Write the different tools in the workflow manager?

993

---

Tell me about MD5 functions in informatica

874

---

What is meant by LDAP users?

1112

---