Answer Posted / kesava reddy

Using Source Qualifier Trnsformation ,
Explantion:
1.Take 2 Source Qualifier Transformations,and
2.One sq ports connect to Target(Unique Target) then Write
a SQL Query (sqlOverride) ,
SELECT DISTINCT EMPNO,ENAME
FROM EMP;
3.TAKE ANOTHER SQ AND CONNECT TO ALL PORTS TO TARGET,THEN
DEVELOP THE SQLOVERRIDE,
SELECT * FROM EMP WHERE ROWID IN(SELECT ROWID FROM EMP
MINUS
SELECT MAX(ROWID) FROM EMP
GROUP BY EMPNO,ENAME)

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

1165

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2010

---

Where are the source flat files kept before running the session?

1067

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1075

---

write a query to retrieve the latest records from the table sorted by version(scd)

1062

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1038

---

How big was your fact table

1795

---

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2333

---

As union transformation gives UNION ALL output, how you will get the UNION output?

1106

---

how we can load rejected record's at run time?(not through bad files)

2374

---

What is a code page?

1169

---

What is an expression transformation in informatica?

1025

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3698

---

Explain pushdown optimization and types in informatica

1065

---

Can we create multiple integration service on single repository?

1181

---