-
-
-
Use of Unused port in Join component.
What is the use of the unused port in the join component? We have reject port. Difference between the reject port & unused port?
-
-
-
How to retrieve las ten or first ten rows from a flatfile
Praful
- Dec 17th, 2012
In datastage, we can use the External Filter stage, use the unix command head or tail to retrieve the particular lines from the flat file.
ambika shanmugam
- May 20th, 2008
Using the SORT operation, we can retrieve the set of records from the flat file Sample command;SORT FIELDS COPYSTOPAFT=10 (stop after 10th record)SKIPREC=10 (skip first 10 records)
-
Informatica triggering
In informatica v 8.6
One workflow triggers another workflow.
How where do we put a distinct clause so that the duplicates are not reflected in the report formed by the second WF. first Wf does a partial load -
1) Differences between DSS and OLTP.2) Explain Grouped cross tab.3) Define Surrogate key.4) What is IQD file.5) Expalin Reference cursor.
Janaki
- Nov 5th, 2012
3.Surrogate key is a sequencer which is used to uniquely identify a row in a OLAP. This helps in implementing SCD Type 2 in data warehousing.
rj_dwbi
- Apr 2nd, 2012
OLAP:
1). Store historical data of an organization
2). Data is used for BI/ business strategic decision
OLTP
1). Real time transactional data
2). Data is used to have track of transaction details. -
SCD types
What are the types of slowly changingdimension ?Can you explain please types of slowly changingdimension in detail ?
vijaya
- Aug 29th, 2012
Slowly changing dimensions are 3 types. In scd-1 new data is inserted by deleting old one. so latest information is stored. In scd-2 we can maintain history of data for a particular item. new data is...
bhavikumehta
- Jun 26th, 2012
SCD are of following types: type 1 - updates changes without preserving history type 2 - stores history data by maintaining versions of the updated data type 3 - either stores current and previous ver...
-
Database and Data Warehouse
What is the relationship between company database and its data warehaouse?
Rajarao marisa
- Jun 6th, 2012
Hi, The main diff between database and data warehouse------> DW 1)Its stores historical & Summarized d...
prasadkawade
- Mar 20th, 2012
Company database contains all the current data. whereas the data warehouse of means data repository. Database stores all the data on which business runs but database repository contains the data that ...
-
What is fan trap? How do you find out? How do you resolve that loop? What is chasm trap? How do you find out? How do you resolve that loop? How you provide security for reports? Whenever you open a report it refresh automatically? How do set this. Can you use different database for different universes? What are the types of universes?
PANGANAMALA SRINIVAS
- May 9th, 2012
Fan trap: one of the schema-tables in your physical realization via an rdbms has a 1:many relationship between two slave-tables but there is no path between the two slave tables! So we are clueless ab...
johnftamburo
- Mar 19th, 2009
A fan trap is a many-to-many relationship between two fact tables, bridged by a dimension.
-
What is the difference between aggregate table and materliazed view?
Read Best Answer
Editorial / Best Answer
joshmohit- Member Since Oct-2010 | Nov 3rd, 2010
Aggregate table is a generic term to represent the summaries built in a warehouse. MAterilaized view is the technical implementation of these aggregate tables. Though, Materialized views come with the database specific properties which might not be covered with the generic definition of aggregate tables.
Tom Haughey
- Apr 30th, 2012
?An aggregate table is a table that contains data that is summarized somehow, for example, it contains a summary of Customer by Product by Week. A more granular level of detail would be the transactio...
joshmohit
- Nov 3rd, 2010
Aggregate table is a generic term to represent the summaries built in a warehouse. MAterilaized view is the technical implementation of these aggregate tables. Though, Materialized views come with the...
-
Data Mining Advantages
What are the advantages of Data Mining over traditional approaches>
Emanisreddy
- Apr 17th, 2012
Data mining is nothing about analyzing the results with different prospects.
-
Relational and Dimensional Data Modeling
How can you say Relational is Normalized one and Data Warehouse i.e Dimensional modeling is De-Normalized one when both model follows the Primary Key Concept in its table to store Data
Iftikhar Alam
- Apr 8th, 2012
Data obtain from transactional source which is normalized on 3NF. It has been staged and demoralized the data and after denationalization of data re-normalized on 2NF and 3NF. Therefore, It is called Demoralized but it is normalized not like the transactional
madhavig
- Feb 16th, 2010
Dimensional modeling usually does with 2NF for dimensions and 3NF for facts.Dimensions are de-normalized for better query performance and for better understanding by business users.
-
Surrogate Key
Why do we use Surrogate Key?
Rajesh Swarnkar
- Feb 28th, 2012
Usually Surrogate keys are System Generated keys that can be used in place of missing primary key.
sadique_ghitm
- Nov 25th, 2011
A surrogate key in a database is a unique identifier for either an entity in the modeled world or an object in the database. The surrogate key is not derived from application data. A surrogate repres...
-
-
-
Hyperion Essbase Dimension and Hierarchy
What difference between dimension and hierarchy>What is mean by maxl?difference between esscmd and maxl?If we are using only dense dimension in outline what will be effect of cube structure?
Sahil
- Oct 25th, 2011
Dimensions are like your lookup tables and Hierarchies forms Dimensions. Inside dimensions there exists hierarchies. Example Employee is a dimension , inside Employee dimensions there can be hierarchies such as Directors hierarchy, Managers Hierarchy and employees Hierarchy etc.,,
karna.siva
- May 20th, 2008
A dimention is nothing but a subject oriented meta data, just like hr section, employees section etc. and the hierarchy is depend on the data source, like "hour glassmodel"Account dime...
-
Replicate vs Broadcast
What is the difference between replicate and broadcast ?
chandana
- Sep 21st, 2011
Replicate supports the component parallelism and broadcast supports data parallelism i.e fan-out,all-to-all.
zann1
- Sep 7th, 2009
Replication moves data to a specified target, usually at a specified time, and usually is usually defined by the ETL team or DBA. Broadcast moves data to targets in the system as needed, and is usuall...
-
Data Warehousing Interview Questions
Sub Category
Questions
Answers
Last Updated
Read Best Answer
Ans