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

Hi, I am Searching on Cognos 8, I don't know how to explain the projects in cognos.Can anybody help me in this regard. My email id is hchereddy@gmail.com. Thanks in advance

IBM,

1948

When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

TCS,

2 9421

When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

5 8695

How are parameters defined in informatica?

HP, TCS,

3 10107

What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?

TCS,

2 14729

What is sql query override? When did u use sql query override?

TCS,

1 7055

Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M

JPMorgan Chase,

6 13525

Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.

2 13870

Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance

2 3994

what is sysdba and sysdbc ? which has high priority ?

Wipro,

3834

which utitility can use for loading the data from non-teradata to teradata ?

Wipro,

5 13404

what is differences between Fastload and Multiload as per DBA aspect ?

Wipro,

1 7029

what is single value and Multivalue ?

IBM, Wipro,

1 6359

we have package it contain Query subject (123456). If u generate report with 6 query subject error will occure how to resolve this problem

IBM,

1 4770

I have prompt date prompt (from and to), country and city, how to get data from jan1/2012 to jan31-2012.

IBM,

2 6799

Un-Answered Questions { Data Warehouse }

how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio

2140

what are the concerns of OLTP and DSS systems?

2450

What are situations where snowflake schema is better than star schema when the opposite is true?

983

What is SAS informats?

1111

what is sas application server, database server, sas olap server and sas metadata server? : Sas-di

1020

How to stop/start redshift cluster?

Explain the difference between nodup and nodupkey options?

1033

Explain in detail scd type 2 through mapping.

1050

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2195

What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?

1102

What is dimensional table?

1072

What is scd type 1 and 2.

895

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2362

Can microstrategy desktop access sap data?

956

What is a Cube?

1148

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