Answer / sbvp

1.FLAG
2.versioning
3.date range
there is three types to implement scd2.

Answer / pune.rohitsharma

my ans is
1)date range
2)key
3)flag
here i have one thing to say
what about with pk key and with out pk will it come into
picture when we are talking about diff ways of implementing
SCD type 2

Answer / kumar raja kotakonda

1) FULL HISTORY
2) DATE RANGE
3) VERSINING
4) FLAGING

Answer / radhakrishnansk

write pl sql scripts

Can u generate reports in Informatica?

0 Answers   Informatica,

---

What is Code Page Compatibility?

1 Answers  

---

What are the differences between joiner transformation and source qualifier transformation?

0 Answers   Informatica,

---

Three date formats are there . How to change these three into One format without using expression transformation ?

3 Answers   HP,

---

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers   IBM,

---

Explain what are the different types of transformation available in informatica.

0 Answers  

---

Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....

2 Answers  

---

Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti

1 Answers   Accenture, Patni,

---

how do u get the first record from 50,000 records ?

10 Answers   TCS, UBS,

---

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

---

What is the Hierarchy of DWH?

1 Answers  

---

In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

1 Answers   Wipro,

---