Answer / rao

THE BEST EXAMPLE IS SCD-1

Answer / abhinaw prakash

when you use dynamic lookup t/r a new row will be added to the lookup(lookup row port).
Use a router for insert and update.
have 2 update strategy t/r and give the xpression lookuprow port as 1(insert) and 2(update).
connect it to the target.

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  

---

What is a sequence generator transformation?

0 Answers  

---

Can you start a batches with in a batch?

1 Answers  

---

in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?

2 Answers   Thomson Reuters,

---

How to call shell scripts from informatica?

0 Answers  

---

---

Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?

6 Answers   iFlex, Morgan Stanley,

---

Are there any types of Dynamic Caches in informatica

4 Answers   Accenture,

---

What is meant by incremental aggregation?

0 Answers  

---

what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  

---

If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   TCS,

---

how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,

---

What is hash partition?

2 Answers  

---