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

a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,

---

What are the types of schemas we have in data warehouse and what are the difference between them?

0 Answers  

---

what is the drillup & drill down?and use of the drill up and drill down?

1 Answers   IBM,

---

if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers   IBM,

---

Differentiate between a repository server and a powerhouse?

0 Answers  

---

Can you start a batches with in a batch?

1 Answers  

---

By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?

8 Answers  

---

How do you handle decimal places while importing a flatfile into informatica?

1 Answers  

---

What is meant by active and passive transformation?

0 Answers  

---

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

0 Answers  

---

Why the workflow is failed after running two hours in informatica?

1 Answers   GE,

---

HOW TO GET THE LATEST DATA IN SCD ?

4 Answers   TCS,

---