Answer / swetha

Data driven.

Insert else update option in which situation we will use

4 Answers   HCL,

---

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 to extract original records at one target & Duplicate records at one target?

12 Answers  

---

what is left outer join?

3 Answers   L&T,

---

Could any one to tell How to use the Oracle Analytic functions in Informatica?

1 Answers  

---

which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,

---

What are the new features of the server manager in the informatica 5.0?

1 Answers  

---

explan ur project architecture?

0 Answers   TCS,

---

in performance wise union is past,union all is past

2 Answers  

---

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

2 Answers  

---

In dimension and fact table? which one holds big data?

2 Answers  

---

What are the types of data warehouses?

0 Answers   Informatica,

---