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

I need an oracle query for convert Char to Integer?. Can any one help me how to do this?

3 Answers  

---

Scenario:-  Below is the requirement. Source:-  NAME          ID                    Requirement  RAVI            1                      (no need to repeat as it ID is 1) KUMAR        3                     (repeat 3 times as it ID is 3) John             4                     (repeat 4 times as it ID is 4) Required Out Put:- Name                   ID RAVI                     1                    KUMAR                3      KUMAR                3 KUMAR                3  John                     4 John                     4 John                     4 John                     4 Scenario 2:- Source Data  ID              NAME 1,2            NETEZZA,ORACLE 3,4,5         SQL Server, DB2, Teradata Required Output:-  ID                   NAME 1                  NETEZZA 1                  ORACLE 3                  SQL Server 3                  DB2 3                  Teradata

1 Answers   Cognizant,

---

How would you join a node to the already existing domain?

0 Answers  

---

How are indexes created after completing the load process?

0 Answers  

---

what is the use of Java Transformation in Informatica 8.x?

2 Answers   TCS,

---

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 Answers  

---

how eliminate the duplicates in flat file with out using sorter ,aggregater

4 Answers   Wipro,

---

What can we do to improve the performance of informatica aggregator transformation?

0 Answers  

---

What is polling in informatica ?

1 Answers   TCS,

---

How identifying bottlenecks in various components of informatica and resolving them?

0 Answers  

---

In joiner, how to load Master table in Target?

2 Answers  

---

Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..

1 Answers  

---