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

why u go for dimensions ?

TCS,

3 9740

what are the difference between Informatica 7.1 and 8.1?

6 32165

Plz..let me know differences between Informatica 7.1 and 8.1?

3 11303

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 8562

How do we create row level security in cognos8?

3 10504

Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

Tech Mahindra,

7 16635

I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...

TCS,

6 14857

What is an open session command in cognos connection?what is it meant for?

Infosys,

1 13885

Please, anyone, let me know the style or an example of using 'by='/'by' variable of a PDV(Program Data Vector)

Verinon Technology Solutions,

3 7617

What is meant by Tabular SQL in Cognos Report net

Infosys,

3 14932

What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?

Deloitte,

10 36746

what are the differences between powercenter 8.1 and powercenter 8.5?

2 9443

wht is full process of Information source to target just like stg to productuon and development

Informatica,

1 7090

what about data stage requirement

1 5279

what is power prompt in cognos ep7series?what is the use of this?

HCL,

3701

Un-Answered Questions { Data Warehouse }

How can you define user defied event?

1043

I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?

2085

what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

1271

During the Display time, how is the sequence generated by Teradata?

1076

Explain me what are conformed dimensions?

1052

Mention what information does a .dbc file extension provides to connect to the database?

1359

What is workflow manager?

1064

What are some different alternative commands associated with "dsjob"?

1181

How co>operating system integrates with legacy codes?

1188

Can you explain dynamic query mode?

1066

Explain functional dependency?

1099

What is a node in Informatica?

1050

What is the difference between check point and phase?

1322

Global and Local shortcuts. Advantages.

2044

Why creation of temporary files depends on the value of MAX CORE ? How to use in abinitio graph? 10. What is the diff between abinitiorc and .abinitiorc files ? How to use in abinitio graph? 11. What is the use of allocate()? How to use in abinitio graph? 12. What is use of branch in EME ? 13. How you can break a lock in EME ? How can you lock a file so that only no one other than EME admin can break it ? How to use in abinitio graph? 14. When you should be using ablocal() ? How you can use ablocal_expr? How to use in abinitio graph? 15. Why you should not keep the layout as 'default' for input table component ? How to use in abinitio graph? 16. What is dynamic lookup ? How to use in abinitio graph? 17. What is dependent parameter ? How to use in abinitio graph? 18. What is BRE ? (Business Rule Environment - This is a recent addition in abinitio package) How to use in abinitio graph? 19.What is output index ? How to use in abinitio graph? 20. How you can track the records those are not getting selected from ‘select’ in reformat component ? How to use in abinitio graph? 21. Can we have more than one launcher process for a particular graph ? How about agent ? How to use in abinitio graph? 22. There are lot of new fuctions added in 2.15 , you can ask about them ? How to use in abinitio graph? 23. How can you run multiple instances of a graph in parallel? How to use

4093

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