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

Difference between Qualify and group

4 17036

i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?

2065

what type of graphs we will create(for 2+years candidates)?

Accenture, Icon,

2311

How to get red line in the graph at some point (value)? Example : In graph at 200000 value

Rolta,

1 3315

Hi frinds pls help me regarding this question WHY usi is two amp operation in teradata? THANKS IN ADVANCE....

3 7108

Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?

Flextronics,

5 11335

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

TCS,

2 8300

How mapping parameter and variable works

1 4257

How to connect mainframe to Abinitio?

CTS,

1 7285

Difference between public and private projects and how to make private to public?

1 8051

what is the difference between i)public ii)private iii)common and client projects?

2231

How to migrate the code FROM development to QA and QA to production?

CTS,

1 8953

difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?

CTS,

2836

Difference between private project parameters ,public project parameters and common project parameters?

1 7633

How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?

2110

Un-Answered Questions { Data Warehouse }

Where the datastage stored his repository?

1089

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1391

what is the difference between querystudio in reportnet and cognos8

2137

Explain attribute role?

1087

what are the filters in framework manager and report studio?

991

How do we convert from Numeric to be Words?

3021

How would you increase the logical size of a table in microstrategy?

974

Is Redshift a row based storage or columnar based?

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?

2501

What are the data marts?

976

How many types of nodes supported by Redshift and what are the functions of nodes?

What are the important Features of Redshift?

can we override a native sql query within informatica? How do we do it?

1127

what is 'reconsideration error' and how can i respond to this error and how to debug this

2633

What is the difference between ods and oltp?

1022

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