Answer Posted / kalyan

Run ur session in Verbose Mode and check out the Busy
Percentage in the Log. IF its more at the Reader thread
than ur Source Query is the Bottleneck.Tune your SQ.

If its Writer thread, then you check with your target . May
be you need to drop and recreate the Indexes on the target
table.

If its the Transformation thread , then check with your
mapping logic. Concentrate More on Aggregator part..

Fine tune your logic. Don't drag the fields which are not
used to all the transformations. try to use as less
transformations as possible.
Cache your lookups .Whenever possible use the persistent
lookup concept.

This should help guys..

How many ways are there to do 'remove duplicate records in informatica'?

986

---

permutations of mapplet

2488

---

can u any challenge your project?

2014

---

What is the use of source qualifier?

1110

---

What are Dimensional table?

1043

---

What is a stored procedure transformation?

1033

---

What is the advantage of informatica?

1050

---

How to load data in informatica ?

984

---

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2012

---

Define update strategy?

1192

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1675

---

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

1895

---

If informatica has its scheduler why using third party scheduler?

1243

---

What is Index Caches size?

1092

---

How we can create indexes after completing the load process?

1143

---