Answer / dharmendra singh

Whenever your record changes and any date column get
updated in source.This happens in mainly transactions where
amount or balance changes.This record is flagged based on
the the date colum which isnow changed and value become
greated then session run time when it was executed
previously.

Answer / ramu

for capturing the changed data in source we use the
incremental loading.

What are the different threads in DTM process?

1 Answers  

---

I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?

3 Answers   ITC Infotech, TCS,

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

0 Answers   TCS,

---

Enlist the various types of transformations.

0 Answers  

---

Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers   Wipro,

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

0 Answers   Informatica,

---

What is a snowflake schema?

0 Answers  

---

What is Target Update Override? What is the Use ?

8 Answers   Patni,

---

tell me the push down optimization

2 Answers   Wipro,

---

Filter transformation in the condition one of the data is NULL would the record be dropped.

2 Answers  

---

To achieve the session partition what r the necessary tasks u have to do?

1 Answers  

---

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

1 Answers   IBM,

---