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 |
I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.
Which commands are used to import and export the datastage jobs?
What is the difference between orabulk and bcp stages?
What are the different layers in the information server architecture?
In a table 100 records are there after 50records job is aborted how can u insert all records in target table.
what is the exact difference between dataset and fileset in datastage?
How to convert RGB Value to Hexadecimal values in datastage?
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
What are the partitioning techniques available in link partitioner?
I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?
in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.
how to sort two columns in single job in datastage.