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 1840

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

1877

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

900

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

1133

EXL informatica Questions

900

Major difference between SQL override and Lookup Sql override

1 2883

How to compare two dmls in abinitio

1122

What Is Snow Flake Schema?

Informatica,

649

What Is The Difference Between Oltp And Olap?

Informatica,

652

What are the reusable transformations?

Informatica,

676

What is the maplet?

Informatica,

595

Explain incremental aggregation in informatica

Informatica,

630

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

Informatica,

621

What is rank transformation in informatica

Informatica,

659

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

Informatica,

665


Un-Answered Questions { Data Warehouse }

Different qualification between a related rotate toward the sky and isolates look upward?

531


Difference between SAS STATA & SPSS?

650


Define pmcmd command?

592


sed,awk,head

946


The question was on time stamp. what is the difference between HH and HH24 when to use when.

1522






What is the difference between router and filter?

627


How to drill through from a powerplay cube to reportnet?

483


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

571


What are the uses of client software involved in teradata?

515


Explain ddl (data definition language)?

556


What all join we can perform in LOOKUP transformation?

535


What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?

692


What are cognos connection initial page components?

578


how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming

570


You can ask about different vector functions. How to use in abinitio graph?

4994