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

5. Which type of report you build more, list, crosstab or chart and why?

IBM,

2063

6. Which of them will increase the performance?

1 3905

7. What is performance tuning?

2059

8. Can you use calculations in report headers and footers? How?

1 4782

9. What was the most complex type of report you dealt with?

2286

10. How many queries did you use in the complex reports? 11. How will you use the joins in the queries used in your report? 12. How many reports did you create in your project? 13. How many cubes did you create in your project? 14. How will you create .iqd file in FM. 15. Was your package multilingual or single language? 16. If you have created a single language package…and you have a client who need to access that in other language…how will you do that? 17. How many dimensions and facts did you use in your reports? 18. How will you use your package in Analysis studio? 19. Something like types of files in power play like pyi..i don’t remember this question. 20. If you want to create a prompt with 4 list, not containing any value using value prompt, which when we will see in the run time…if we will select any list, it should show us the data related to that list. 21. What all kind of packages you can create using FM. 22. In your project was your cube a relational or multidimensional? 23. I replied MD for the above question then they asked why did you use that? 24. How do you publish a cube? 25. Slicer and dicer….its use…where is it used? 26. Bursting…. 27. How many types of query subjects are there? 28. Difference between before and after aggregation?

2554

Hi, Webi report is created using universeA and this report needs to be shifted to UniverseB.So when i am trying to change report to new universeB from edit query properties, the report just hangs at the point of changing source to target.The reports which hangs mainly are the crosstab reports that has large data and many formulas. Any help on this is much appreciated. Thanks

1 5709

Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,data skew,cpu skew, io skew, delta amp cpu ?

2 15021

How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?

1 4264

what is the difference between application based and web based in cognos?can you please give a example from out of EP 7 series and 8 series?genrel exampel please?

HCL,

2 5142

what is slowly growing dimension??

Accenture,

6 17685

How can you find out whether datastage process is running or not in unix?

Accenture,

3 25328

when will you go for dataset and fileset?

Accenture,

2 15010

how can i abort the job if i get more than 100 errors in job log?

Accenture,

6 24931

wt is the diff b/w odbc and oracle stage

Accenture, HCL,

2 20408

Un-Answered Questions { Data Warehouse }

Do we need an etl tool?

1065

Explain connectivity between datastage with datasources?

1043

What is the difference in creating filters in designer and business objects?

1085

How to join 3 database like flat file, oracle, db2 in informatrica?

1337

What actually a project contains?

1154

Where $mpjret is used in ab-initio?

1198

what is hash files in sas and why we are using this one in sas?

2272

What is the use of datastage director?

1079

create a job that splits the data in the Jobs.txt file into four output files. You will direct the data to the different output files using constraints. • Job name: JobLevels • Source file: Jobs.txt • Target file 1: LowLevelJobs.txt − min_lvl between 0 and 25 inclusive. − Same column types and headings as Jobs.txt. − Include column names in the first line of the output file. − Job description column should be preceded by the string “Job Title:” and embedded within square brackets. For example, if the job description is “Designer”, the derived value is: “Job Title: [Designer]”. • Target file 2: MidLevelJobs.txt − min_lvl between 26 and 100 inclusive. − Same format and derivations as Target file 1. • Target file 3: HighLevelJobs.txt − min_lvl between 101 and 500 inclusive. − Same format and derivations as Target file 1. • Rejects file: JobRejects.txt − min_lvl is out of range, i.e., below 0 or above 500. − This file has only two columns: job_id and reject_desc. − reject_desc is a variable-length text field, maximum length 100. It should contain a string of the form: “Level out of range: ”, where is the value in the min_lvl field. My Question is how do you write the stage variable for reject rows.

2782

What is a method to debug and test your SAS program?

1445

explain one complex mapping with logic? sales project?

6738

what is flow of project?

2061

Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

1988

How can you import XML repositories exported from different tools like ODI

3604

Which means the first record should come as last record and last record should come as first record and load into the target file?

1144

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