Data Warehouse General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Warehouse General Interview Questions

Questions Answers Views Company eMail

How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?

952

How can we acheive correlated sub-query in designer?can anyone help me in this regard?

890

What is the working process for application.cfm?

982

Is there any rownum object from which we can do this?

875

What is index awareness in universe?

953

What is data stream and data adaopter?

1022

What are the advantages of cold fusion?

905

How can you set the session management?

1051

I need to set predefined condition. How I do this?

956

What are steps we have to follow in designing the userfriendly universe?

922

Difference between cold fusion mx 6 and cold fusion mx 7?

799

How can you set the client management?

958

Explain in detail abt measure objects? And what is the use of it? How to create it?

943

In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?

998

What is mean by aggregate aware?

987

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

How to export mappings to the production environment?

836

Explain what is ods (operation data source)?

929

Why facts table is useful in representing the data?

931

What is the use of incremental aggregation? Explain me in brief with an example?

976

What is an error log table in informatica occurs and how to maintain it in mapping?

910

What are the different ways to represent the loading of dimension tables?

881

What are the stages of datawarehousing?

951

What is a core dimension?

1014

Fact table is in normalized or de-normalized form?

908

What are aggregate tables and aggregate fact tables?

964

Explain why denormalization is promoted in universe designing?

908

What is application.cfm?

1001

What is junk dimension? What is the difference between junk dimension and degenerated dimension?

1017

What is is a star schema?

1066

Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?

999

For More Un-Answered { Data Warehouse General } Questions Click Here