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 primary and backup node?

1174

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1168

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2417

---

Why is sorter an active transformation?

1198

---

Explain the use of aggregator cache file?

1318

---

Which transformation is needed while using the Cobol sources as source definitions?

1221

---

what is the size of your data warehousing?

2146

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

1142

---

What is the function of union transformation?

1204

---

Define enterprise data warehousing?

1257

---

How you can differentiate between connected lookup and unconnected lookup?

1107

---

What is different between the data warehouse and data mart?

1114

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2108

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1821

---

What do think which one is the better joiner or look up?

1247

---