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

2365

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

Wipro,

1 6863

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

Wipro,

1 8844

dumps needed ASAP for - C2020-180 Cognos IBM Certification

Aptech,

2210

Which component breaks the pipe line parallelism in graph?

Wells Fargo,

3 19804

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 10389

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

1 2951

How does the session recovery work.

1 3102

Why use shortcuts(Instead of making copies).

1 3535

where is the reject loader .

1 2752

How do you use reject loader.

2616

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

1 3811

Differences between version 7.x and 8.x.

Accenture, Cognizant,

1905

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.

2367

Mapplets can you use an active transformation in a mapplet,

1 3332

Un-Answered Questions { Data Warehouse }

Why do you think data processing is important?

1142

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

1397

how to export or import the jobs in .ISX file

1212

can you change the location of the obiee repository?

858

What are the advantages of informatica?

1022

What is cognos powerhouse?

1035

What is intricate mapping?

1218

What is the purpose of _character_ and _numeric_?

1073

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1809

why is sas data integration studio important? : Sas-di

1049

What are the transformations that are not supported in mapplet?

1041

What is teradata and why it is used?

1108

how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

2147

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1548

What are the types of schemas we have in data warehouse and what are the difference between them?

953

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