|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Fact table - Table with Collection of Foreign Keys corresponding to the Primary Keys in Dimensional table. Consists of fields with numeric values. Dimension table - Table with Unique Primary Key. Load Latest Answer : __________________ _______________ ________________|_________________| |______________ ... First we execute the jobs that load the data into Dimension tables, then Fact tables, then load the Aggregator tables (if any). Latest Answer : Simply by using "usage variyable" stage in job sequencers. ... The above might rise another question: Why do we have to load the dimensional tables first, then fact tables: As we load the dimensional tables the keys (primary) are generated and these keys (primary) are Foreign keys in Fact tables. A. The jobs in which data is read directly from OCI stages are running extremely slow. I had to stage the data before sending to the transformer to make the jobs run faster.B. The job aborts Scenario based Question ........... Suppose that 4 job control by the sequencer like (job 1, job 2, job 3, job 4 )if job 1 have 10,000 row ,after run the job only 5000 data has been loaded in target table remaining are not loaded and your job going to be aborted then.. How can short out the problem. Suppose job sequencer synchronies or control 4 job but job 1 have problem, in this condition should go director and check it what type of problem showing either data type problem, warning massage, job View Question | Asked by : Mukesh Kumar Madhav Latest Answer : Incremental load means daily load.when ever you are selecting data from source, select the records which are loaded or updated between the timestamp of lastsuccessful load and todays load start date and time.for this u have to pass parameters for those ... Read Answers (2) | Asked by : ramaiah 1 1. Difference between Hashfile and Sequential File?. What is modulus?2 2. What is iconv and oconv functions?.3 3. How can we join one Oracle source and Sequential file?.4 4. How can we implement Slowly Changing Dimensions in DataStage?.5 5. How can we implement Lookup in DataStage Server jobs?.6 6. What are all the third party tools used in DataStage?.7 7. what is the difference between routine and transform and function?.8 8. what are the Job parameters?.9 9. Plug-in?.10 10.How can we improve Read Answers (1) | Asked by : Zias Latest Answer : What is ur source?. Depending on type of source, you have to use respective stage.like oracle enterprise: u can use this for oracle source and target.similarly for other sources.Hanu. ... Latest Answer : Once we have loaded our dimensions, then as per business requirements we identify the facts(columns or measures on which business is measured) and then load into fact tables.. ... Read Answers (2) | Asked by : Prashant Narayani Latest Answer : In a star schema there will be facts and dimension tables to load in any datawarehouse environments. You will generaly load the Dimension tables first and then Facts.Facts will have the relative information of dimension.HTHThanksRaghu Mule ... Read Answers (2) | Asked by : sivanov21
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
