Data Warehouse Interview Questions
Questions Answers Views Company eMail

what is the difference between == and eq in UNIX shell scripting?

CTS,

942

To see hidden files in LINIX?

CTS,

914

sed,awk,head

CTS,

946

How to read the length of word in unix?

CTS,

854

options available in sequence job to run,validate?

CTS,

809

What is the difference between validate and compile?

CTS,

1 3122

How to convert alpha Numeric values to alpha using functions?

CTS,

1 2046

what is the use of materialized view?

CTS,

933

table actions available in oracle connector?

CTS,

1060

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

TCS,

1100

Can we get 1st record through Informatica(without sequence number).

940

In Which Transformation We Can Use Having Clause In Informatica?

809

Can you implement SCD2 using join, transformer and funnel stage?

Cognizant,

1058

In your project what type of issues and errors you facing in Teradata

iGate,

1 1536

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

Saama Tech,

1037


Un-Answered Questions { Data Warehouse }

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

591


How can a transformation be made reusable?

644


What is cubes?

598


What are the statements that are executed only?

651


How to generate sequence numbers using expression transformation?

616






What are pre and post-session shell commands?

704


What do the put and input function do?

561


What is intricate mapping?

564


Explain teradata utilities?

544


Nls stands for what in datastage?

700


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

524


what is enterprise guide? What is the use of it? : Sas programming

518


What is conduct>it?

611


Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low

827


what can you learn from the sas log when debugging? : Sas programming

579