Answer Posted / srinu

1.Confirmed Dimension-
The dimensions which is used more than one fact table is
called conformed dimensions.
Ex-Product Dimension related to Order fact, Sles fact,,,,.

2.Junk Dimension-
A "junk" dimension is a collection of random transactional
codes, flags and/or text attributes that are unrelated to
any particular dimension.
A good example would be a trade fact in a company that
brokers equity trades.
fact would contain several metrics (principal amount,net
amount, price per share, commission, margin amount, etc.)
and would be related to several dimensions such as account,
date, rep, office, exchange, etc.


3.Degenerated Dimension-
In a data warehouse, a degenerate dimension is a dimension
which is derived from the fact table and doesn't have its
own dimension table.
ex-line no in a Facttable,,,,

4.Slowly changing Dimensions-
A Slowly Changing Dimension (SCD)is a dimension that
changes over time.It may change immediately and it may also
change quite rapidly.
ex-nothing but Inserts,updates,,,,

Any corrections:-
Srinu.srinuvas@gmail.com

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2078

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4164

---

can u any challenge your project?

2034

---

How can you differentiate between powercenter and power map?

1092

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2037

---

Is it possible to define a single node as a Gateway node as well as worker node?

1123

---

What are ETL Tools?

1121

---

How do you convert single row from source into three rows into target?

1158

---

Why update strategy and union transformations are active? Explain with examples.

1243

---

How an expression transformation differs from aggregator transformation?

1044

---

Where can we find the throughput option in informatica?

1065

---

what is diff b/t sorter t/r and agg have the option sorter property...

2181

---

What is dimensional table?

1069

---

Explain the aggregator transformation?

1169

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8203

---