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

How we can call macros with in data step? : sas-macro

1066

What is the maximum length of the macro variable? : sas-macro

1054

How long can a macro variable be? A token? : sas-macro

1163

What are symget and symput? : sas-macro

1252

What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro

988

What do you code to create a macro? : sas-macro

1074

Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro

1141

How do you add a number to a macro variable? : sas-macro

955

Can you execute a macro within a macro? Describe. : sas-macro

1072

For what purposes have you used sas macros? : sas-macro

956

How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro

997

what is the purpose of _error_? : Sas programming

1086

what are input dataset and output dataset options? : Sas programming

1037

if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming

1011

how can you put a "trace" in your program? : Sas programming

1011

Un-Answered Questions { Data Warehouse }

how does sas handle missing values in a merge? : Sas programming

990

How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC

1951

What are the different modes to run i-server?

986

Can you explain the co>operating system’s processing model?

1050

What is a joint child?

899

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1933

Where the cache files stored?

962

What is the status code in stored procedure transformation?

1128

how would u estimate the size of Aggregator transform data and index cache?

2381

What are types of partition primary index (ppi) in teradata?

1007

Under which circumstances, informatica server creates reject files?

1033

What is cube grouping?

1000

in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt

1856

Mention what is the syntax for m_dump in abinitio?

1414

When we use aggregate awareness function in designer?

910

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