Informatica - what r the defferent types of dimension tables?how can we join the table if they have no matching po

GeekInterview.com > Tech FAQs > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 24 of 304

what r the defferent types of dimension tables?

how can we join the table if they have no matching point and related keys?

Total Answers and Comments: 5

Last Update: June 30, 2006 Asked by: kishore

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

May 14, 2006 01:25:03

amar_smmath

Member Since: April 2006 Contribution: 7

RE: what r the defferent types of dimension tables?

the difft. types of dimensions are

1.confirmed 2.junk dimension

1.confirmed: confirmed dimension is that dimension table which has 100% relationship to share with the other tables.

Is this answer useful? Yes | No

May 27, 2006 03:48:24

sreedhar

what r the defferent types of dimension tables?

it is very simple generate numbers by using sq _ trsfms for both tbls and perform the fjoins

Is this answer useful? Yes | No

June 02, 2006 07:16:11

Manas

RE: what r the defferent types of dimension tables?

Anothe approch would be... create one dummy fileld by an expression in both. Then join the two using the dummy field.

Is this answer useful? Yes | No

June 24, 2006 17:06:45

kareemuddin ahmed

RE: what r the defferent types of dimension tables?

what is junk dimeasion?

Is this answer useful? Yes | No

June 30, 2006 02:39:39

Motilal

RE: what r the defferent types of dimension tables?

There are many types of dimension tables.

Till now there have no particular type of classification.

You can find them in "Datawarehousing Toolkit" by Ralf Kimphbell.

Some of them are,-Confirmed, Junk, Degenerated, Time, Demographic, Slowly Changing, Rapidly Changing, etc.. around 16 types are there.

Is this answer useful? Yes | No