Answer / Manish Kumar Chaurasia

"To create indexes in Informatica, you would typically perform this operation outside of Informatica, using database management tools such as SQL Server Management Studio or Oracle Database Manager. Indexes are usually created on target tables during the load process."

What is the difference between normal and bulk loading? Which one is recommended?

1 Answers  

---

What is limitations of truncate and load option

1 Answers   Cap Gemini,

---

source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.

4 Answers   TCS,

---

How can you increase the performance in joiner transformation?

1 Answers  

---

In a sequential batch can u run the session if previous session fails?

3 Answers  

---

hw cn v elimate dublicate values from lookup without overriding sql?

7 Answers   CTS,

---

Define Pmrep command?

1 Answers  

---

Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??

3 Answers   IBM,

---

Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?

6 Answers  

---

What are the different transaction levels available in transaction control transformation?

1 Answers   Informatica,

---

Explain incremental aggregation in informatica

1 Answers   Informatica,

---

what are the limitation of sorter transformation?

2 Answers   TCS,

---