Data Warehousing Interview Questions

May 14 2006
02:18 PM

2471
Views

0
Ans

Hi I urgently need some precise infos to the following questions..What kind of data will be stored in a big mortgage company data warehouse?What is the size of tables(number of row, column), number of records?Also how do you conduct a dta warehouse testing? steps of warehouse testing?Thanks

damd

Data Warehousing Interview Questions

Answer Question
Oct 11 2006
09:13 AM

2762
Views

0
Ans

What are the new features in Ab Initio 2.14 and tell about webserver feature in Ab Initio2.14?

phaneendra

Data Warehousing Interview Questions

Answer Question
Apr 03 2007
03:42 AM

2855
Views

0
Ans

Which of the following is NOT a common use of the data analysis technique?Integrate complex business data in an easy to understand mannerAllow DW support team to visualize the DW loading in a real time basisAllow exploration of complicated data in an interactive mannerDisplay statistical data using maps and charts

Chandrashekhar

Data Warehousing Interview Questions

Answer Question
Apr 03 2007
03:42 AM

2893
Views

0
Ans

A common DQM problem in data warehousing is Loading data because it is availableGaining consensus on data definitionsIncorporating external data, text, images, sound and videoData stored in unstructured manner

Chandrashekhar

Data Warehousing Interview Questions

Answer Question
Apr 03 2007
03:43 AM

2982
Views

0
Ans

Centralized metadata architecture gives primary advantage forSource data analysisTarget data analysisCounterpart metadata buildEnd to end impact analysis

Chandrashekhar

Data Warehousing Interview Questions

Answer Question
Apr 03 2007
03:43 AM

3190
Views

0
Ans

Design module includes all of the following EXCEPTSpecify data integrity rulesSpecify requirements definitionsSpecify data transformation rulesSpecify traceability to requirements

Chandrashekhar

Data Warehousing Interview Questions

Answer Question
Apr 03 2007
03:44 AM

2948
Views

0
Ans

A common capacity problem with Data Warehousing involvesData extract transfer of bulk filesNetwork overloadInadequate BRAPComplex data structure

Chandrashekhar

Data Warehousing Interview Questions

Answer Question
Apr 03 2007
03:44 AM

3507
Views

0
Ans

Implementing a referential integrity in DW environmentSupports analytical performance in the databaseCreates issues in fact loadingSupports implementing a table for each dimension attributeResults into analytical performance issues

Chandrashekhar

Data Warehousing Interview Questions

Answer Question
May 22 2007
02:24 PM

2944
Views

0
Ans

What is purpose of derived variable in universe?

ramanasv

Data Warehousing Interview Questions

Answer Question
Aug 08 2007
02:48 PM

2460
Views

0
Ans

How to restrict number of CPUs used by deployed Ab Initio Shell script.

Kishor B

Data Warehousing Interview Questions

Eg: Suppose on my Unix server I have 24 CPUs and I have to restrict to only 10 CPU utilization by Ab Initio script at runtime.

Answer Question
Aug 18 2007
01:27 PM

2004
Views

0
Ans

How to create sequence keys in data stage server edition?

prasad

Data Warehousing Interview Questions

Answer Question
Aug 20 2007
04:37 AM

3102
Views

0
Ans

How do you change a four way multifile to a 8 way multifile in Abinitio?

Surya

Data Warehousing Interview Questions

Answer Question
Aug 20 2007
07:52 AM

5140
Views

0
Ans

How to do dense_rank in Informatica?

ram kuamr

Data Warehousing Interview Questions

I want result as eno ename salary dense_rank100 A 10000 1200 B 9000 2300 C 9000 2400 D 8000 3

Answer Question
Sep 01 2007
06:27 AM

2694
Views

0
Ans

How Hibernate is related with Data Warehouse?

gaurav bhuyar

Data Warehousing Interview Questions

Answer Question
Sep 06 2007
03:37 AM

3410
Views

0
Ans

How to laod a SCD2 dimension.

Rakesh20878
Profile Answers by Rakesh20878 Questions by Rakesh20878

Data Warehousing Interview Questions

For a customer update transaction it should be inserted in customer table as a new record or as a insert with a new surrogate key.

Answer Question
Sep 12 2007
05:20 AM

3627
Views

0
Ans

Explain the difference between an ETL developer and an ETL consultant. (if there is any differnce at all)? If so who has more responsibilities?

mahendra nath

Data Warehousing Interview Questions

Answer Question
Sep 14 2007
06:02 PM

2576
Views

0
Ans

In Free hand SQL, what are the steps of Query Optimization?

Sunil

Data Warehousing Interview Questions

Answer Question
Sep 17 2007
09:30 AM

2119
Views

0
Ans

How to derive a datawarehouse from datamarts?

ssuvi
Profile Answers by ssuvi Questions by ssuvi

Data Warehousing Interview Questions

Answer Question
Oct 03 2007
05:19 AM

1683
Views

0
Ans

How to connect Report Studio Directly to datasource?

Raju

Data Warehousing Interview Questions

Answer Question
Oct 06 2007
08:43 AM

1758
Views

0
Ans

What are the uses of S-Keys?

Anu

Data Warehousing Interview Questions

Answer Question

Data Warehousing Interview Questions

Hi I urgently need some precise infos to the following questions..What kind of data will be stored in a big mortgage company data warehouse?What is the size of tables(number of row, column), number of records?Also how do you conduct a dta warehouse testing? steps of warehouse testing?Thanks

What are the new features in Ab Initio 2.14 and tell about webserver feature in Ab Initio2.14?

A common DQM problem in data warehousing is Loading data because it is availableGaining consensus on data definitionsIncorporating external data, text, images, sound and videoData stored in unstructured manner

Centralized metadata architecture gives primary advantage forSource data analysisTarget data analysisCounterpart metadata buildEnd to end impact analysis

Design module includes all of the following EXCEPTSpecify data integrity rulesSpecify requirements definitionsSpecify data transformation rulesSpecify traceability to requirements

A common capacity problem with Data Warehousing involvesData extract transfer of bulk filesNetwork overloadInadequate BRAPComplex data structure

Implementing a referential integrity in DW environmentSupports analytical performance in the databaseCreates issues in fact loadingSupports implementing a table for each dimension attributeResults into analytical performance issues

What is purpose of derived variable in universe?

How to restrict number of CPUs used by deployed Ab Initio Shell script.

How to create sequence keys in data stage server edition?

How do you change a four way multifile to a 8 way multifile in Abinitio?

How to do dense_rank in Informatica?

How Hibernate is related with Data Warehouse?

How to laod a SCD2 dimension.

Explain the difference between an ETL developer and an ETL consultant. (if there is any differnce at all)? If so who has more responsibilities?

In Free hand SQL, what are the steps of Query Optimization?

How to derive a datawarehouse from datamarts?

How to connect Report Studio Directly to datasource?

What are the uses of S-Keys?

Latest News

It looks like you are using an AD Blocker!

Login

Data Warehousing Interview Questions

Hi I urgently need some precise infos to the following questions..What kind of data will be stored in a big mortgage company data warehouse?What is the size of tables(number of row, column), number of records?Also how do you conduct a dta warehouse testing? steps of warehouse testing?Thanks

What are the new features in Ab Initio 2.14 and tell about webserver feature in Ab Initio2.14?

A common DQM problem in data warehousing is Loading data because it is availableGaining consensus on data definitionsIncorporating external data, text, images, sound and videoData stored in unstructured manner

Centralized metadata architecture gives primary advantage forSource data analysisTarget data analysisCounterpart metadata buildEnd to end impact analysis

Design module includes all of the following EXCEPTSpecify data integrity rulesSpecify requirements definitionsSpecify data transformation rulesSpecify traceability to requirements

A common capacity problem with Data Warehousing involvesData extract transfer of bulk filesNetwork overloadInadequate BRAPComplex data structure

Implementing a referential integrity in DW environmentSupports analytical performance in the databaseCreates issues in fact loadingSupports implementing a table for each dimension attributeResults into analytical performance issues

What is purpose of derived variable in universe?

How to restrict number of CPUs used by deployed Ab Initio Shell script.

How to create sequence keys in data stage server edition?

How do you change a four way multifile to a 8 way multifile in Abinitio?

How to do dense_rank in Informatica?

How Hibernate is related with Data Warehouse?

How to laod a SCD2 dimension.

Explain the difference between an ETL developer and an ETL consultant. (if there is any differnce at all)? If so who has more responsibilities?

In Free hand SQL, what are the steps of Query Optimization?

How to derive a datawarehouse from datamarts?

How to connect Report Studio Directly to datasource?

What are the uses of S-Keys?

Latest News

It looks like you are using an AD Blocker!