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

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 Answers  

---

Difference between session variables and workflow variables?

2 Answers   Informatica,

---

what is row level and column level indicator?

1 Answers   TCS,

---

what are the reusable tasks in informatica ?

11 Answers   CTS, HP, IBM, TCS,

---

How union transformation is active ?

2 Answers   Puma,

---

---

Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.

7 Answers   Cognizant, Wipro,

---

How to open an older version of an object in the workspace?

0 Answers  

---

where does the default group roew in a router is stored what is the default size of memory in router

1 Answers  

---

After we make a folder shared can it be reversed?Why?

2 Answers   Accenture,

---

what is datamart

4 Answers   IBM, Informatica,

---

While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?

4 Answers  

---

Describe two levels in which update strategy transformation sets?

1 Answers  

---