Differentiate between operational datastage (ods) and data warehouse?
No Answer is Posted For this Question
Be the First to Post Answer
You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?
How to perform incremental load in datastage?
1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?
What are the components of ascential data stage?
Define Merge?
What is data partitioning?
How many nodes supported by a one cpu in parallel jobs?
How do you get log info into a file?
What are the environmental settings for data stage,while working on parellel jobs?
I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?
How do you import and export the datastage jobs?
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?