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

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2507

---

Describe expression transformation?

1044

---

Can you use flat files in Mapplets.

2609

---

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

1950

---

Performance tuning in UNIX for informatica mappings?

2505

---

Explain how many types of dimensions are available in informatica?

1005

---

What are the different types of transformation available in informatica.

1028

---

What does role playing dimension mean?

996

---

What is standalone command task?

1256

---

What are the uses of etl tools?

1064

---

Can anyone tell me the new features in Informatica 9 Version?

2031

---

What is flashback table ? Advance thanks

1871

---

Sequence generator, when you move from develoment to production how will you reset

1939

---

What is a repository? And how to add it in an informatica client?

1081

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1032

---