Answer / chandumba2005

• Increase performance by indexing the primary key-foreign
keys if the source table has more than 1,000 rows
• Improve session performance by caching small lookup tables
• Use reusable Lookup transformation instead of using same
Lookup Transformation multiple times
• Use source filter in the Properties tab to reduce the
number of rows
• Reduce the number of transformation.
• Delete unnecessary links between transformations to
minimize the amount of data moved, especially in the Source
Qualifier
• Plan for reusable transformations
• Use mapplets to encapsulate multiple reusable transformations.
• Use variable ports to calculate a value that can be used
multiple times
• Numeric operations are faster than string operations
• Operators are faster than function. Example: || is faster
than concat()

Explain Dataware house architecture .how data flow from intial to end?

0 Answers   Keane India Ltd,

---

What is a filter transformation and why it is an active one?

0 Answers  

---

How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important

4 Answers   CTS,

---

What are the tasks that can be performed using sq?

0 Answers  

---

how to move the mappings from your local machine to claint place?

2 Answers  

---

What are the circumstances that infromatica server results an unreciverable session?

1 Answers  

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

---

I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers   Cap Gemini, IBM,

---

checkout and checkin in informatica 8.6

3 Answers   TCS,

---

in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?

2 Answers   Thomson Reuters,

---

To achieve the session partition what r the necessary tasks u have to do?

1 Answers  

---

. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null

3 Answers  

---