-
What is the need for an ODS(operational data store)
What is the need for an ODS(operational data store) in data warehousing?What are the advantages of using an ODS?
-
SQL and PLSQL
What is the difference between SQL & PLSQL?
-
Debug stages in PX
What are the different Debug stages available in Datastage PX?
-
Connect two sources
How to connect two sources with connecting field without using joiner and lookup?
-
Apply Business Rules
Where do we apply business rules from souce to staging or staging to warehouse?
-
Informatica Mapping level Questions
in mapping level we have update strategy in that we have DD-update and at session level we have DD_insert when we run mapping what will happen is it inserted or updated?
-
Datastage Lookups
Please let me know how many lookups is there in Parallel Jobs.
-
-
-
-
-
-
What is the way to add the total number of records that have been read from SRC in the TGT file as last line?
What is the way to add the total number of records that have been read from SRC in the TGT file as last line? Let me clear you if my TGT is a flat file and want to add total number of records that are written in TGT as a last line with sysdate.
-
-
-
What is a Star Schema
Answer posted by Chintan on 2005-05-22 18:34:55: A relational database schema organized around a central table (fact table) joined to a few smaller tables (dimension tables) using foreign key references. The fact table contains raw numeric items that represent relevant business facts (price, discount values, number of units sold, dollar value, etc.)