Answer Posted / sudhar

You can use distinct to eliminate the duplicate records.

Otherwise if you wanted to send the duplicate records to
another table then sort the data, then using the expression
you can find the duplicate value, assign different constant
values for the duplicate and the normal one. Use the router
to send duplicate and orginal records to the different
target tables.

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

1367

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7113

---

What is sq transformation?

1073

---

How can you generate reports in informatica?

971

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1196

---

What are the types of lookup transformation?

1020

---

Explain the shared cache and re-cache?

1048

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1099

---

Differentiate between a repository server and a powerhouse?

1041

---

server hot-ws270 is connect to Repository B. What does it mean?

2437

---

 Informatica Checkpoints

3264

---

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??

970

---

Which files are created during the session rums by informatics server?

1121

---

What does command task mean?

1060

---

What is the use of code page?

1004

---