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

Difference between output_index and output_indexes in reformat

1298

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

921

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

837

1 1582

Intern stastical programmer written test

760

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

781

Tell me about MD5 functions in informatica

929

Tell me about Propagate functions in informatica

923

How to update a particular record in target with out running whole workflow?

1577

How you prepared reports for OLAP?

1597

How you know when to use a static cache and dynamic cache in lookup transformation?

1856

how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio

2137

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

2023

how to insert/update a csv file by comparing it with another csv file?

2568

Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.

2216

Un-Answered Questions { Data Warehouse }

where to store informatica rejected data? How to extract the informatica rejected data?

1007

What is the function you would use to transfer a string into a decimal?

1220

Tell us about the architecture of abinitio.

1099

Give some examples where proc report’s defaults are same as proc print’s defaults?

1113

you are required to disable webusers to use only one i-server. How would you do that?

892

What is dimensional table? Explain the different dimensions.

1174

The methods to improve performance of a graph?

1078

please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.

2194

it will become easy if uuu provide website linkssss and list of consultanciessssss

1981

Dear all, Please send me the ab initio pdfs and faqs i need... my mail id is rrajesh.intel@gmail.com

2324

How many ways are there to do 'remove duplicate records in informatica'?

1018

Explain what are components of reportnet?

975

I'm busy writing a report that's using report bursting, to be able to do this I need to use a sequential section. Using a sequential section cause the grouping of the original report not to work. Please can someone give me advise on how to come past this problem, the report need to use grouping as it depend largely on totals ect, and I need to use a sequential section within the report to be able to use the report bursting facility.

2779

What is the difference between datawarehousing and businessintelligence?

1102

Explain sessions. Explain how batches are used to combine executions?

1034

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