Answer / sumankumar

type2 scd it wil maintain historical informtion + currnt
information along with 3 options .....
1.effective date
2.version number
3.flag value

Answer / chaitanya

Using SCD2 mapping Target warehouse can store recent data+ complete historical data

Type2 dimension mapping or SCD2 mapping can be implemented in 4 ways: i)Limited number of Histories
ii)Star Schema support implementation
iii)Unlimited number of Histories
iv)Unconnected Stored Procedure

what is difference between COM & DCOM?

1 Answers   Satyam,

---

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,

---

what is shared lookup&persistent lookup?

4 Answers   Accenture, Cap Gemini,

---

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

0 Answers   Informatica,

---

what is constraint based loading

2 Answers   IBM,

---

Can you use one mapping to populate two tables in different schemas

2 Answers  

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

0 Answers  

---

what is surrogate id ?

3 Answers   IBM,

---

what is target update override and when we use it?

2 Answers   TCS,

---

Differnce between filter and router?

14 Answers   IBM,

---

i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four

3 Answers  

---

how to get the data from the client machine and how to get server location data to client loction can any body explain to me

1 Answers   TCS,

---