Answer / sambasivarao.m

Hi,

find below testing points at mapping level that might be
help you..

Verify Mapping is Available
Verify parameters are defined properly with proper
datatypes
Verify whether the shorcut to source table is used as
source in the mapping from replica connection
Verify whether WHERE clause in the SQ has used properly to
implement delta condition
Verify whether the primary key is selected properly in the
target table
Verify whether versioning is maintained
Verify Source name used in the mapping
Verify Target name used in the mapping
Changes made to the existing mapping(if applicable)
Verify whether the new fields handled for NULL values(if it
is a NOT NULL column in the Target table)
Verify whether lookup is added to the mapping(if applicable)
Verify whether the Lookup override used is proper
Vefify whether the condition for Insert/Update is used in
UPDATE STATERGY transformation
Verify Whether the Filter condition used is proper

Regards,
Sambasivarao.m

What are the types of caches in lookup? Explain them.

0 Answers  

---

My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000

3 Answers   TCS,

---

How to delete duplicate row using informatica?

0 Answers  

---

wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,

---

i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers   HCL, HP,

---

How can you recover the session in sequential batches?

1 Answers  

---

What is a surrogate key?Why we use it in a mapping?Pl give an example.

4 Answers   PCS,

---

What is the difference between Power Centre and Power Mart?

5 Answers   TCS,

---

What are the performance considerations when working with aggregator transformation?

0 Answers  

---

How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?

2 Answers   Rolta,

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

0 Answers   Wipro,

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

0 Answers  

---