there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

4 Answers  

---

how do u tune queries?

1 Answers  

---

How can you change from reusable session into non-reusable session.

5 Answers   Cap Gemini,

---

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,

---

What are the phases in SDLC?

3 Answers  

---

How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 Answers  

---

What are the main features of Oracle 8i with context to datawarehouse?

0 Answers  

---

what are the reusable tasks in informatica ?

11 Answers   CTS, HP, IBM, TCS,

---

what are surrogate keys?

5 Answers  

---

What are Business Components in Informatica?

1 Answers  

---

How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

2 Answers   TCS,

---

What is joiner transformation in informatica?

0 Answers  

---