What modeling tool do you use?
Answers were Sorted based on User's Feedback
Answer / kalyanreddy
Hi Ram,
Ans : Erwin
Basically these tools using for prepare LDM and PDM.
We are referring PDM while loding the data to DIM
Tables are facts.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / pavan
To shady,
Yeah we need to understand the model developed by the tools
As this model is a refernce kind of thing during loading a
table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / shady
is this related to datastage.....DS is as far as i know is
ETL tool.does modelling come under ETL ie Datastage.....guys
plz clarify
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / kiran
Modeling done by BI modeler and its used for Reporting
Purpose only.Don't think in ETL
| Is This Answer Correct ? | 0 Yes | 2 No |
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?
how to load meta data
I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically
Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel suneel suneel suneel suneel how it will get. Please design job with explain. Thanks.
What's the Main Function of the Staging area in DWH
Difference between server jobs & parallel jobs?
What is Cleanup Resources and when do you use it?
How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.
ename like ibm,tcs,hcl need display those records only how?
How to add zero "0" before record in a field?