Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Please explain in detail with example about
1.Confirmed Dimension.
2.Junk Dimension.
3.Degenerated Dimension.
4.Slowly changing Dimensions

Question Posted / usha

Answer Posted / 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

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where do we use mapping variables in informatica?

1120

what is index?how it can work in informatica

2083

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

1172

What are the measure objects?

1255

Enlist the various types of transformations.

1120

Different sorts of metadata that stores in the storage facility?

1069

Describe an informatica powercenter?

1192

Can we create multiple integration service on single repository?

1240

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

2158

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1336

my source is junk data how will u remove that junk data by using unix please any one replay me

3755

What do you mean incremental aggregation?

1129

Explain in detail scd type 2 through mapping.

1091

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2170

Can we create a node as a gateway node and the same node can be assigned to a grid?

1125