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

Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.

1 2649

a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron

2470

can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

1378

i have input like this TABA 1 TABA 2 TABA 3 TABA 4 TABB 7 TABB 8 TABC 1 TABC 2 TABC 5 OUT PUT NAME COL1 COL2 COL3 COL4 TABA 1 2 3 4 TABB 7 8 TABC 1 2 5

1623

EXL informatica Questions

1390

Major difference between SQL override and Lookup Sql override

1 4299

How to compare two dmls in abinitio

1831

What Is Snow Flake Schema?

Informatica,

1205

What Is The Difference Between Oltp And Olap?

Informatica,

1125

What are the reusable transformations?

Informatica,

1166

What is the maplet?

Informatica,

1119

Explain incremental aggregation in informatica

Informatica,

1130

How to generate sequence numbers without using the sequence generator transformation?

Informatica,

1206

What is rank transformation in informatica

Informatica,

1179

How to improve the performance of a session using sorter transformation?

Informatica,

1146

Un-Answered Questions { Data Warehouse }

How to Create a folder using pmrep command?

1173

Performance tuning in UNIX for informatica mappings?

2568

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3346

During the Display time, how is the sequence generated by Teradata?

1054

please please give me some banking calculations in framework manager.

2087

What is confirmed fact in dataware housing?

6968

Explain dimensional modelling?

984

What are algorithms provided by Microsoft in SQL Server?

2054

How do you connect the desktop application to metadata server? : sas-grid-administration

1096

what actually happens when bulk load mode starts?

When and why we should use Redshift Spectrum?

Can reports be executed in off-peak periods?

997

Mention some file extensions which are used in abinitio?

1120

how can we analyze the locks ?

2132

What is the difference between regular dimension and derminant?

2275

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