Answered Questions

  • Why we can't create an aggregate on an ODS Object?

    Javid

    • May 3rd, 2007

    Hi,This is a common question, asked anywhere.While loading into the Datawarehouse we gather data(source) from different source systems and place it in a STAGING area - which is literally called as ODS...

  • What is the difference between Consiner and Consinee?

    Owner of the asset, Feacture Owner of the Particular Asset.

    Pintal Chauhan

    • Jul 23rd, 2016

    Consignor means a person who deliver the goods and services to the customer and Consignee is the person who receive the goods and services from the consignor.

    prudhvi

    • Nov 7th, 2015

    Consignor=Owner
    Consginee=Customer

  • What is the Difference between OLTP and OLAP

    Answered by swetha on 2005-03-30 12:00:33: OLTP  Current data Short database transactions Online update/insert/delete Normalization is promoted High volume transactions Transaction recovery is necessary   OLAP Current and historical data Long database transactions Batch update/insert/delete Denormalization is promoted Low...

    ram

    • Aug 30th, 2016

    OLTP: Original Source of data
    Running on fundamental business task

    OLAP: Data coming from various OLTP sources
    Problem Solving, Decision Making

    Pravin

    • Jan 16th, 2015

    Very useful answer.
    thanks.