Answer Posted / 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 conditions needed to improve the performance of informatica aggregator transformation?

1083

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1684

---

What are the different lookup cache(s)?

1107

---

What is the meaning of decode in informatica?

1118

---

What are the prerequisite tasks to achieve the session partition?

1243

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2065

---

What is the use of transformation?

990

---

What are the steps involved in the migration from older version to newer version of Informatica Server?

2100

---

What is the function of aggregator transformation?

1076

---

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

2101

---

Explain the shared cache and re-cache?

1104

---

What's the layout of parameter file (what does a parameter file contain?)?

2379

---

How to generate sequence numbers?

1075

---

What is deployment group?

1198

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1043

---