mahesh225


{ City } chennai
< Country > india
* Profession * developer
User No # 112343
Total Questions Posted # 0
Total Answers Posted # 9

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 13
Users Marked my Answers as Wrong # 0
Questions / { mahesh225 }
Questions Answers Category Views Company eMail




Answers / { mahesh225 }

Question { TCS, 6809 }

what is meant by slowly changing dimensions?


Answer

The data present in the dimension table changess from time to time.

For example .

Customer is staying in Inda now and he may moves to Us in next year.Similerly from Us to Uk and so on.

So to maintain this kind of dimentional historical information we have SCD type1,Type2 and Type3.

www.futuresoftworld.com

Thanks

Is This Answer Correct ?    0 Yes 0 No

Question { AG Technologies, 9021 }

can we create aliases for every table beforehand? if yes
whar are the disadvantages?


Answer

We cannot create alias for all tables.
Because alias will make extra table and extra join .This is one of the disadvantage .

For confirmed dimentions we cannot create a alias.

www.futuresoftworld.com

Thanks

Is This Answer Correct ?    0 Yes 0 No


Question { Polaris, 8921 }

What is conformed dimension?


Answer

A dimension table is created once and shared across multiple fact tables is called confirmed dimension.

www.futuresoftworld.com
www.candygig.com

Thanks

Is This Answer Correct ?    0 Yes 0 No

Question { TCS, 12892 }

How many ways you can restrict data in business objects?


Answer

There are many ways to restrict the data in Bo.

Universe side

1)Universe join
2)Object where class
3)Universe prompts
4)you can also ristrict the data by creating derived tables with certain condtions

Report side

1)Query Filter
2)Report Filter
3)Quick(show/hide)Report Filter
4)Creating variables with certain conditions like

=If([Country]="USA") Then 1 else 0

select 1 to display only USA data.

www.futuresoftworld.com

Thanks

Is This Answer Correct ?    1 Yes 0 No

Question { L&T, 7167 }

What is scope of analysis ?


Answer

Scope of analysis will desides the level of navigation which you can go for the analysis either it may be one level ,two level or custom level.

For example

Region==>Country (One level down)
Region==>Country==>City (Two levels down)
Region==>Country==>City==>State (three levels down)

like wise and so on N levels..

Is This Answer Correct ?    5 Yes 0 No

Question { 8302 }

what is difference between scd2 and scd3


Answer

SCD Type2 maintains the complete history and SCD Type3 will maintains one time history.

www.futuresoftworld.com
www.futureitem.com

Is This Answer Correct ?    1 Yes 0 No

Question { 4047 }

which institute and which faculty is providing best training for oracle sql, plsql in hyderabad


Answer

Hi ,

My openion would be Naresh technologies in Ameerpet.

iLogic is good for data warehousing. You can check with people and take appropriate decission.

www.futuresoftworld.com

Thanks

Is This Answer Correct ?    1 Yes 0 No

Question { Oracle, 2356 }

I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?


Answer

Hi

There are lot of sites which are available in the internet.You can just search for it and start learning from the basics.

Also you can seach for youtube to find online classes .
This may also help you.

www.futuresoftworld.com

Is This Answer Correct ?    0 Yes 0 No

Question { JPMorgan Chase, 6413 }

which table we load first in DW. dimension or fact? why?


Answer

Dimension tables will be loaded first.

www.futuresoftworld.com
www.futureitem.com

Is This Answer Correct ?    5 Yes 0 No