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

Could anyone give brief explanation bout datastage admin

2362

how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?

Wipro,

1 6855

what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none

Wipro,

1 8839

dumps needed ASAP for - C2020-180 Cognos IBM Certification

Aptech,

2207

Which component breaks the pipe line parallelism in graph?

Wells Fargo,

3 19799

Can we use where and having clauses in a single SAS program. ex: proc sql; select a,b,c from test where state in 'KA' and having . Is the above program run correctly, if not why ?

UHG,

4 10381

How do you change parameter when you move it from development to production.

1 2950

How does the session recovery work.

1 3097

Why use shortcuts(Instead of making copies).

1 3529

where is the reject loader .

1 2749

How do you use reject loader.

2614

Do you have to change the reject file b4 using reject loader utility.

1 3810

Differences between version 7.x and 8.x.

Accenture, Cognizant,

1903

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2366

Mapplets can you use an active transformation in a mapplet,

1 3331

Un-Answered Questions { Data Warehouse }

Describe link sort?

1018

What is domain and gateway node?

1173

Can you explain repository tables in datastage?

1415

Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

979

--------------Explain Table of contents?

2032

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1207

What do you mean by dimensional modeling and relational modeling? Which one do you use in dw? Why?

965

What is the cumulative sum and moving sum?

1192

After we create a scd table, can we use that particular dimension as a dimension table for star schema?

999

Explain is data mart?

1029

On which transformations you created partitions in your project?

1355

What is the complex report you faced in real time?

2187

What are the different operating system platforms in which we can use sas? : sas-grid-administration

1080

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

1028

What is the differentiate between data file and descriptor file?

1368

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