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

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

1.Have u logical models in project? If s which logical model used? 2.how do u connect to production server? 3. how do u test the data in report is same as in DWH? 4. u created one report but there is no data in the attribute. But how can u extract the data from ware house? 5. u have two tables having different ids how do u merge those table in MSTR? 6. have u faced challenging situation in u r project? Give me one example?

1 2644

Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

IBM,

3 7887

Can we have more than one time dimensions in a Schema(Star or Snowflake)

ASD Lab, IBM,

1 6493

how to merge 2 crosstabs thans

HCL,

1 2710

how to create calculate column in report studio

4 9428

what is the use of lock and unlock

1 5937

which type of project we r going to snowflake schema

IBM,

1 2036

can we create a chart without measure

3 8006

diff b/w dimension and regular dimension

1 5366

diff b/w layout calculation and query calculation

Cap Gemini,

2 7543

how to connect datamarts

HCL,

1 2879

diff b/w grouping and aggregation

HCL,

1 6346

how to improve performance in report studio level

Wipro,

1 6631

without using rank transformation how can we rank items by using some other transformations

2 15402

i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four

3 7395

Un-Answered Questions { Data Warehouse }

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

847

faq's on cognos

4113

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

2095

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1101

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1212

Explain in detail about scd type 1 through mapping.

1646

Explain about a tricky situation for which you found a very simple solution?

1080

Write the unconnected lookup syntax and how to return more than one column.

1174

What is rollup component?

1337

How do you remove duplicate records in informatica? And how many ways are there to do it?

1233

Demonstrate experience in maintaining quality process standards?

2674

Hi, If anyone has base SAS certification dumps, please share.

1940

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1964

Explain about a time when you discovered a more efficient way to do a work task?

1224

what are the data modeling tools you have used?(polaris)

2060

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