Answer / sanjay

By using the scd2..we can keep the track of the old and new
records.
There are 3 ways:
1.Version Num
2.Date
3.Flag

Answer / srikanthlavu

old values you might store in target right?then use that
old values for comparision of new values by using lookup
tranformaton....give key port lkp t/n from sq and give
condition like oldvalue=newvalue
if condition true means those are old vakues

in which situations do u go for scds ?

3 Answers   TCS,

---

what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 Answers  

---

what is degenerated dimension?

1 Answers   IBM,

---

How to identify this row for insert and this row for update in dynamic lookup cache

3 Answers   CSC,

---

What are the reusable transforamtions?

2 Answers  

---

If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?

4 Answers  

---

what is system requirement(SR) & business requirement(BR)?

2 Answers   Ness Technologies,

---

waht is dataware house

2 Answers  

---

How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

3 Answers   Logica CMG,

---

empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.

3 Answers  

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

0 Answers  

---

Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?

3 Answers   Syntel,

---