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?
it is possible to load two tables data into one sequential file?if possible how?plz share with me?
Is the value of staging variable stored temporarily or permanently?
Why do you need stage variables?
what is the use of surogate key in datastage
What is a range lookup?
What is container and then types?
What is the difference between server job and parallel jobs?
What is the use of datastage director?
What are the different type of jobs in datastage?
What are the unit test cases you used in your project?
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.