Answer / swetha

Insert

Delete

Update

Update as update

Update as insert

Update esle insert

Truncate table

Answer / santhoshi

INSERT
UPDATE AS UPDATE
UPDATE AS INSERT
UPDATE ELSE INSERT
DELETE
TRUNCATE TARGET TABLE

How are indexes created after completing the load process?

0 Answers  

---

What is the difference between warehouse key and surrogate key?

1 Answers   Accenture,

---

What is standalone command task?

0 Answers  

---

if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,

---

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

0 Answers  

---

In which scenario did u used Mapping variable?

1 Answers   Cognizant,

---

How to eliminate duplicates from flat file..what is the procedure

4 Answers  

---

How can a transformation be made reusable?

0 Answers   Informatica,

---

Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer

2 Answers  

---

What are active and passive transformations?

0 Answers   Informatica,

---

how can i invoke pmcmd in command line prompt

1 Answers  

---

which one is better either active or passive transformation in informatica

1 Answers  

---