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 are cascading prompts explain with steps

4 24434

what is static filter and dynamic filter

1 11966

when and where we use @varialble function

1 6408

is there any limit for rows and columns in cross tab

4 15421

how to overcome overflow of data in a report

6 21879

What is incremental aggregation and how it is done?

JPMorgan Chase, TCS,

8 39309

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

Virtusa,

4 13240

we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?

2 6313

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in

2 6583

what is aggregate navigation?

Countrywide, CTS, HCL,

3 27019

what is casual dimension?

CA,

1 7406

how do u implement dense rank in a report?

CTS,

1 4567

Difference between scope of analysis in webi and in deski?

CA,

1 12514

what is maximum scope of analysis --> can we define more than 3 levels?

CTS,

2 10895

how do u implement dense rank in bo reports?

CTS,

2 24833

Un-Answered Questions { Data Warehouse }

What are the data types present in bo? What happens if we implement view in the designer and report?

1082

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1100

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2104

Explain how to generate iqd file from framework manager?

1020

faq's on cognos

4112

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2306

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1670

How to add default rules in transformer?

1284

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2546

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4796

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4192

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2342

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6075

hi i want to learn microstratogy please anyone help to me which institute is best in bangalore any one having related documents ,and video link please mail to this id avanthireddykv@gmail.com

2299

What sort of existing documents should business analysts refer to when starting on a new project?

1078

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