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

what is environment variables and parameters?

1 8286

how many types of project we can create in Abinitio? I mean public,private.......etc?

1 8405

To which project that prefix will set is to private project or public project or both?how and where to set?

1861

what is the project environment(for each project the environment is same or different to different project)?

2232

I have a DML in my local system the location is E:/u/home/khaleel/dml how to convert this path to $DML?

1 4253

What is the difference between formal and export parameter? Export at what secenario we are going to use?

2652

I have $AI-SERIAL/DML------> (SERIAL FILE LOCATION) AND $BDS-SERIAL/DML---------->(what is the location what is mean)?

1 4647

How to create project (public,private,common,client) what are the differences between them?

TCS,

1 8606

)what is wrapper script?where it is going to execute and why we go for wrapper?

Satyam,

1 16188

How to move or copy the project parameter or project object to my sandbox?

2319

what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?

4011

what is the use of catlog or catlogfile?

2386

what is SSH?What is the differences between the SSH,SSH1,SSH2?

2 10346

what is the use of stdenv in abinitio and what the main concept belongs to is?what is env?

1 12489

How to move data from developement to testing and testing to production?

BitWise, CTS, Satyam, Wipro,

1 14948

Un-Answered Questions { Data Warehouse }

Difference between cold fusion 5 and cold fusion mx 6?

1003

how to do user inputs and command line arguments in sas?

3059

I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

2109

What are the five ways to do a table lookup in sas? : sas-grid-administration

1073

What are the main features of datastage?

1291

What is informatica worklet?

1076

Could you explain what is enterprise data warehouse?

1160

what is transformation in sas data integration? : Sas-di

1044

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!!!

2199

what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

1147

Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?

1130

table actions available in oracle connector?

1620

What is informatica metadata and where is it stored?

1003

What are the databases that informatica can connect to windows?

1065

Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2347

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