What are the major differences between Informatica 7.1,8.1,8.5 and 8.6?
What are dimensions?
What is difference between stored procedure transformation and external procedure transformation?
What are aggregations?
What is OLTP?
Explain time series algorithm in data mining?
What are cubes?
What are measures?
What are fact tables?
What are the benefits of data warehousing?
What is a data mart?
What is the approximate size of a data warehouse?
How many ways U can update a relational source definition and what r they?
What are the types of External Loader available with Informatica?
Which is better among connected lookup and unconnected lookup transformations in informatica or any other ETL tool?
Explain about Recovering sessions?
What is a time dimension? give an example.?
Can u copy the session to a different folder or repository?
How to use mapping parameters and what is their use?
What r the joiner caches?
How can u recover the session in sequential batches?
Explain about Recovering sessions?
What kinds of data belong in a data warehouse?
Why would I want to access the data warehouse when I have a mainframe computing system?
Definitions of decision tree on the Web?
What?s metadata? What?s a data dictionary?
Definitions of electronic data exchange on the Web?
Definitions of software agent on the Web?
Definitions of public key certificate on the Web?
What do you know about Datawarehousing ?
State some of the benefits of dataware housing?
What are the different interconnected layers of a dataware house?
Can a Data Warehouse also be used for Transaction Database?
What is the use of bridge table. Can give a simple example?
Explain about the top design?
How does replication takes place between two sites?
Explain about the time variant feature of Dataware housing?
What are the steps to build the data warehouse?
What is DATA integration?
Explain about the non-volatile feature of dataware house?
What are Data Marts?
Explain some disadvantages of dataware house?
What is real time data-warehousing?
Explain about hybrid design model?
What is data mining?
Explain about the bottom up design?
Which is the optimized method of extracting the data?
What are the similarities between ROLAP and MOLAP?
State some of the disadvantages of data ware houses?
What is the purpose of "Factless Fact Table"? How it is involved in Many to many relationship?
What do you think about the future of data warehousing?
How do you connect two fact tables ?Is it possible ?
What are the general stages of use of dataware house?
Can a dimension table contains numeric values?
State two major differences between a dataware house and operational dataware house?
What are the advantages data mining over traditional approaches?
Explain about the integrated dataware house stage?
What is the main difference between Inmon and Kimball philosophies of data warehousing?
What is junk dimension? What are junk dimension and degenerated dimension?
What is Data warehousing Hierarchy?
What is a look up table?
What is a CUBE in data warehousing concept?
How are the Dimension tables designed?
Is it correct/feasible develop a Data Mart using an ODS?
What is ODS?
Why should you put your data warehouse on a different system than your OLTP system?
Why is Data Modeling Important?
What is ETL?
What does level of Granularity of a fact table signify?
What is SCD1 , SCD2 , SCD3?
Why are OLTP database designs not generally a good idea for a Data Warehouse?
What are the various Reporting tools in the Market?
What are conformed dimensions?
What are the Different methods of loading Dimension tables?
What is conformed fact?
What are non-additive facts?
How Do I Make Remarks In My Code?
What type of Indexing mechanism do we need to use for a typical data warehouse?
What is a general purpose scheduling tool?
Name some of modeling tools available in the Market?
Explain the advanatages of RAID 1, 1/0, and 5. What type of RAID setup would you put your TX logs.?
What is VLDB?
What is the datatype of the surrogate key ?
What is degenerate dimension table?
What are the methodologies of Data Warehousing.?
What is a linked cube?
What are the different architecture of datawarehouse?
What are the possible data marts in Retail sales.?
What is the difference between view and materialized view?
What is active data warehousing?
What is the difference between Datawarehousing and Business Intelligence?
What is snapshot?
What are non-additive facts in detail?
What is a level of Granularity of a fact table?
What is Virtual Data Warehousing?
What is XMLA?
Why is SAS so popular?
What is data cleaning? How can we do that?
Explain in brief about critical column?
How to Add VB script to web pages ?
What is source qualifier?
Difference between DSS & OLTP?
Explain grouped cross tab?
Hierarchy of DWH?
How many repositories can we create in Informatica?
What is surrogate key?
What is difference between Mapplet and reusable transformation?
What is aggregate awareness?
Explain reference cursor?
What are parallel querys and query hints?
DWH architecture?
What are cursors?
Advantages of de normalized data?
What is operational data source (ODS)?
What is meta data and system catalog?
What is factless fact schema?
What is confirmed dimension?
What is the capacity of power cube?
Difference between PowerPlay transformer and power play reports?
What is IQD file?
What is Cognos script editor?
What is difference macros and prompts?
What is power play plug in?
Which kind of index is preferred in DWH?
What is hash partition?
What is DTM session?
How can you define a transformation? What are different types of transformations in Informatica?
What is mapplet?
What is query panel?
What are dimensions?
What is difference between stored procedure transformation and external procedure transformation?
What are aggregations?
What is OLTP?
Explain time series algorithm in data mining?
What are cubes?
What are measures?
What are fact tables?
What are the benefits of data warehousing?
What is a data mart?
What is the approximate size of a data warehouse?
How many ways U can update a relational source definition and what r they?
What are the types of External Loader available with Informatica?
Which is better among connected lookup and unconnected lookup transformations in informatica or any other ETL tool?
Explain about Recovering sessions?
What is a time dimension? give an example.?
Can u copy the session to a different folder or repository?
How to use mapping parameters and what is their use?
What r the joiner caches?
How can u recover the session in sequential batches?
Explain about Recovering sessions?
What kinds of data belong in a data warehouse?
Why would I want to access the data warehouse when I have a mainframe computing system?
Definitions of decision tree on the Web?
What?s metadata? What?s a data dictionary?
Definitions of electronic data exchange on the Web?
Definitions of software agent on the Web?
Definitions of public key certificate on the Web?
What do you know about Datawarehousing ?
State some of the benefits of dataware housing?
What are the different interconnected layers of a dataware house?
Can a Data Warehouse also be used for Transaction Database?
What is the use of bridge table. Can give a simple example?
Explain about the top design?
How does replication takes place between two sites?
Explain about the time variant feature of Dataware housing?
What are the steps to build the data warehouse?
What is DATA integration?
Explain about the non-volatile feature of dataware house?
What are Data Marts?
Explain some disadvantages of dataware house?
What is real time data-warehousing?
Explain about hybrid design model?
What is data mining?
Explain about the bottom up design?
Which is the optimized method of extracting the data?
What are the similarities between ROLAP and MOLAP?
State some of the disadvantages of data ware houses?
What is the purpose of "Factless Fact Table"? How it is involved in Many to many relationship?
What do you think about the future of data warehousing?
How do you connect two fact tables ?Is it possible ?
What are the general stages of use of dataware house?
Can a dimension table contains numeric values?
State two major differences between a dataware house and operational dataware house?
What are the advantages data mining over traditional approaches?
Explain about the integrated dataware house stage?
What is the main difference between Inmon and Kimball philosophies of data warehousing?
What is junk dimension? What are junk dimension and degenerated dimension?
What is Data warehousing Hierarchy?
What is a look up table?
What is a CUBE in data warehousing concept?
How are the Dimension tables designed?
Is it correct/feasible develop a Data Mart using an ODS?
What is ODS?
Why should you put your data warehouse on a different system than your OLTP system?
Why is Data Modeling Important?
What is ETL?
What does level of Granularity of a fact table signify?
What is SCD1 , SCD2 , SCD3?
Why are OLTP database designs not generally a good idea for a Data Warehouse?
What are the various Reporting tools in the Market?
What are conformed dimensions?
What are the Different methods of loading Dimension tables?
What is conformed fact?
What are non-additive facts?
How Do I Make Remarks In My Code?
What type of Indexing mechanism do we need to use for a typical data warehouse?
What is a general purpose scheduling tool?
Name some of modeling tools available in the Market?
Explain the advanatages of RAID 1, 1/0, and 5. What type of RAID setup would you put your TX logs.?
What is VLDB?
What is the datatype of the surrogate key ?
What is degenerate dimension table?
What are the methodologies of Data Warehousing.?
What is a linked cube?
What are the different architecture of datawarehouse?
What are the possible data marts in Retail sales.?
What is the difference between view and materialized view?
What is active data warehousing?
What is the difference between Datawarehousing and Business Intelligence?
What is snapshot?
What are non-additive facts in detail?
What is a level of Granularity of a fact table?
What is Virtual Data Warehousing?
What is XMLA?
Why is SAS so popular?
What is data cleaning? How can we do that?
Explain in brief about critical column?
How to Add VB script to web pages ?
What is source qualifier?
Difference between DSS & OLTP?
Explain grouped cross tab?
Hierarchy of DWH?
How many repositories can we create in Informatica?
What is surrogate key?
What is difference between Mapplet and reusable transformation?
What is aggregate awareness?
Explain reference cursor?
What are parallel querys and query hints?
DWH architecture?
What are cursors?
Advantages of de normalized data?
What is operational data source (ODS)?
What is meta data and system catalog?
What is factless fact schema?
What is confirmed dimension?
What is the capacity of power cube?
Difference between PowerPlay transformer and power play reports?
What is IQD file?
What is Cognos script editor?
What is difference macros and prompts?
What is power play plug in?
Which kind of index is preferred in DWH?
What is hash partition?
What is DTM session?
How can you define a transformation? What are different types of transformations in Informatica?
What is mapplet?
What is query panel?
No comments:
Post a Comment