Answer / raveendra g

One dimension which used more than one cube called
Confirmed dimension.
Junk dimension is nothing but Durty. We have to take
unrelated attributes and data into maintain single table
called junk dimension.
DD: The value of the dimension which is stored in the
factable called Degenerated Dimension
SCD: The value of the dimension is happen to change very
rarely and commonly called SCD.
3 Types of SCDS we are having
SCD1: Only current
SCD2: Current+History, Here we can add rows
SCD3: Current+just recent, Here we can add columns level
data.

Answer / usha

1.Confirmed Dimension:- the dimensions that are bult once
and can be use reused in multiple fact tables

2.Junk Dimension:- the dimension which is used to cerate
junk attributes

3.Degenerated Dimension:- The dimension that are located
in fact table


4.Slowly changing Dimensions:- The dimensions that chaanfes
slowly over a period of time.

Types

SCD type1
SCD type2
SCD type3

Answer / vasu

check all pevious Questions and Answers in
Allinterview.com

what are the output files that the informatica server creats during running a session?

2 Answers   CTS,

---

What happens when a session fails and you click on recover?

0 Answers  

---

i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers   Accenture,

---

What is Datadriven?

2 Answers   Informatica,

---

Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?

2 Answers   Infotech,

---

---

Diffrence between static and dynamic cache

2 Answers   HCL,

---

how many data models u have done in informatica project?

2 Answers   TCS,

---

How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,

---

write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh

5 Answers   Accenture,

---

What are the challenges you have faced in your project?

1 Answers   Cognizant, Infosys,

---

What are the associated ports in look up T/R.

5 Answers   IBM, Zensar,

---

By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?

14 Answers   CSC, Emphasis,

---