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

Explain the flow of data in Iinformatica?

1 Answers  

---

Explain the code page compatibility?

0 Answers  

---

Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers   Wipro,

---

Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.

0 Answers  

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

0 Answers  

---

where to store informatica rejected data?

0 Answers  

---

scd methodology?

2 Answers  

---

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,

---

After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?

6 Answers  

---

Why is meant by direct and indirect loading options in sessions?

4 Answers  

---

What is informatica? What exactly are the practical uses in real world

2 Answers  

---

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 Answers  

---