Data Warehouse Interview Questions
Questions Answers Views Company eMail

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

CTS,

979

To see hidden files in LINIX?

CTS,

948

sed,awk,head

CTS,

974

How to read the length of word in unix?

CTS,

888

options available in sequence job to run,validate?

CTS,

843

What is the difference between validate and compile?

CTS,

1 3184

How to convert alpha Numeric values to alpha using functions?

CTS,

1 2115

what is the use of materialized view?

CTS,

967

table actions available in oracle connector?

CTS,

1099

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,

1124

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

990

In Which Transformation We Can Use Having Clause In Informatica?

829

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

Cognizant,

1095

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

iGate,

1 1581

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,

1088


Un-Answered Questions { Data Warehouse }

How we are going to decide which schema we are going to implement in the data warehouse?

490


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1644


How can we update a record in the target table without using update strategy?

658


What is meant by query override?

640


Start a batches with in a batch?

557






What makes sas stand out to be the best over other data analytics tools?

591


Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

1600


Have you used rollup component? Describe how.

664


What is ods (operation data source)?

555


Describe a time when you were really stuck on a problem and how you solved it?

2086


Where can we find the throughput option in informatica?

600


What is Cognos script editor?

3788


What is the difference between informatics 7x and 8x and what is latest version?

547


At which levels you can set the vldb properties? Which level has the highest pecedence?

540


What is meant by target load plan?

559