Answer Posted / tadikonda

if u have toad, u can find the tool option tab under that
ESTIMATE TABLE SIZE option,in that u can define the table
name and schema name ,in that way u can find which table is
big in size

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

1115

---

Explain the different lookup methods used in informatica?

1098

---

What is a rank transform?

1146

---

Performance tuning in UNIX for informatica mappings?

2625

---

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,

7237

---

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

1122

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1958

---

Explain why we use partitioning the session in informatica?

1164

---

waht type of interface is used for testing the data in informatica

2300

---

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

1247

---

Can we create two repositories on same database instance in oracle?

1144

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2247

---

What is the need for an etl tool?

1103

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1689

---

Scheduling properties,whats the default (sequential)

2014

---