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 is the maplet?

1091

---

Describe expression transformation?

1112

---

How to load a Dimension ? and how to load a fact table?

1402

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1067

---

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

1246

---

complex mapping ur project u r invlve can u explain and give real time example give me ?

2272

---

can we override a native sql query within informatica? How do we do it?

1106

---

What do you understand by SOA of Informatica?

963

---

What are the different types of olap? Give an example?

1033

---

What is a pre-defined event and user-defined event?

1025

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1973

---

What is pmcmd command?

1086

---

define galaxy repository in informatica

2205

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2117

---

How does a sorter cache works?

1044

---