How many types of dimensions are available in Informatica? - There r 3 types of dimensions 1.star schema 2.snowflake schema 3.glaxy schema - Informatica Interview Questions and Answers

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

DATA WAREHOUSING

INFORMATICA

DETAILS

Question: How many types of dimensions are available in Informatica?

Answer: There r 3 types of dimensions

1.star schema

2.snowflake schema

3.glaxy schema

Category	Informatica Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 9227 users
Added on	8/18/2011
Views	73722
Rate it!

Question: How many types of dimensions are available in Informatica?

Answer:

There r 3 types of dimensions

1.star schema

2.snowflake schema

3.glaxy schema
Source: CoolInterview.com

3 types.That are

1. SCD(slowly changing dimension) type1
2. SCD type2
3. SCD type3
Source: CoolInterview.com

Answered by: ram | Date: |

Contact ram

The types of dimensions available are:
1. Junk dimension
2. Degenerative Dimension
3. Conformed Dimension
Source: CoolInterview.com

Answered by: sri | Date: |

Contact sri

ONE OF IT IS CONFORMED DIMENSION
Source: CoolInterview.com

Answered by: INDIRA | Date: |

Contact INDIRA

3 types of SCD
Type 1 : For only updated data.
Type 2 : For Present and full history of data
Type 3 : For present and previous data. Source: CoolInterview.com

Answered by: sanjay | Date: |

Contact sanjay

1.SCD-type1:-it maintains current(updated) data.
2.SCD-type2:-it maintains historical data.
3.SCD-type3:-it maintains present n previous(partial history) data.
4.conformed dimension. Source: CoolInterview.com

Answered by: Swathi Reddy | Date: 3/15/2008 |

Contact Swathi Reddy

Simple pass through mapping
Slowly Growing target
Slowly Changing dimensions:
Type1 SCD
Type2 SCD
Type3 SCD Source: CoolInterview.com

Answered by: saritha | Date: 4/21/2008 |

Contact saritha

there r 3 types
scd type1
scd type2
scd type3
type1:-dimensional table maintains only the current data in warehouse system.
type2:-dimensional table maintains complete historical data and current data in warehouse system.
type3:-dimensional table maintains current data and recent history in warehouse system... Source: CoolInterview.com

Answered by: ramesh | Date: 8/11/2010 |

Contact ramesh

in datawarehouseing system we can find fallowing types dimension tables
1> scd dimension tables
2> confirmed dimension tables
3> zanu dimension tables
4> time dimension tables Source: CoolInterview.com

Answered by: ramesh | Date: 8/11/2010 |

Contact ramesh

1.star schema

2.snowflake schema

3.glaxy schema

Source: CoolInterview.com

Answered by: kishore reddy | Date: 8/14/2010 |

Contact kishore reddy

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	When we create a target as flat file and source as oracle.. how can i specify first rows as column names in flat files...	View Answer
	1.can u explain one critical mapping? 2.performance issue which one is better? whether connected lookup tranformation or unconnected one?	View Answer
	How can you improve the performance of Aggregate transformation?	View Answer
	Why did you use stored procedure in your ETL Application?	View Answer
	why did u use update stategy in your application?	View Answer
	How do you create single lookup transformation using multiple tables?	View Answer
	In update strategy target table or flat file which gives more performance ? why?	View Answer
	How to load time dimension?	View Answer
	What is a source qualifier?-	View Answer
	After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can u map these three ports directly to target?	View Answer
	How can u work with remote database in informatica?did u work directly by using remote connections?	View Answer
	What is power center repository?	View Answer
	What r the types of metadata that stores in repository?	View Answer
	Define informatica repository?	View Answer
	What is difference between maplet and reusable transformation?	View Answer
	What is difference between partioning of relatonal target and partitioning of file targets?	View Answer
	What is parameter file?	View Answer
	Can u start a batches with in a batch?	View Answer
	What is batch and describe about types of batches?	View Answer
	Can u copy the session to a different folder or repository?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Informatica Interview Questions & Answers - Exam Mode / Learning Mode