Is it possible to update the target table with PK?

1 Answers   TCS,

---

what is persistant cache in which situation we will use persistantcache

1 Answers   HCL,

---

without using emailtask how will send a mail from informatica?

3 Answers  

---

What are the advantages of using informatica as an etl tool over teradata?

0 Answers  

---

checkout and checkin in informatica 8.6

3 Answers   TCS,

---

---

What are data-driven sessions?

0 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,

---

What does update strategy mean, and what are the different option of it?

0 Answers  

---

What is the difference between Power Centre and Power Mart?

5 Answers   TCS,

---

Could you explain what is enterprise data warehouse?

0 Answers  

---

why we are using level option in normalizer transformation

1 Answers   TCS, Wells Fargo,

---

one source to target loading insert new rows and update existing rows?

3 Answers   Polaris,

---