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

Why do you use Mapping Parameter and mapping variable?

0 Answers  

---

how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,

---

Could any one to tell Fact table Partitioning?

2 Answers  

---

Explain how many types of dimensions are available in informatica?

0 Answers  

---

which is better perfomancewise lookup or joiner and why?can anyone give example?

6 Answers   TCS,

---

how to create user defined function (udf) in informatica

0 Answers   Informatica,

---

Performance tuning( what you did in performance tuning)

0 Answers   Infosys,

---

can you use flat file for lookup table?why?

2 Answers   HCL,

---

any body can say about all versions of informatica ?how many versions ?

2 Answers  

---

complex mapping ur project u r invlve can u explain and give real time example give me ?

0 Answers   HGS, TCS,

---

what are types of dimentions?

3 Answers  

---

What is the way to execute pl/sql script using informatica mapping?

0 Answers  

---