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 Cognos script editor?

4235

---

Name the different lookup cache(s)?

1235

---

How to load the data from a flat file into the target where the source flat file name changes daily?

1063

---

Which development components of informatica have the highest usage?

1044

---

Define pmcmd command?

1047

---

generate date / time dimension in informatica

1126

---

What is substr in informatica?

1209

---

How to handle decimal places while importing a flatfile into informatica?

1192

---

What does cheating measurement mean?

1064

---

What are the guidelines to be followed while using union transformation?

1145

---

Informatica settings are available in which file?

991

---

In how many ways we can create ports?

1123

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2201

---

What all join we can perform in LOOKUP transformation?

978

---

What are the advantages of informatica?

1014

---