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 |
can we use sequential file as a lookup
1)How to Duplicate Records Delete in Sequential file?
how to retrive the max(sal),deptno,empno in datastage?
What is the difference between validated and compiled in the datastage?
What are the different layers in the information server architecture?
what is the use of materialized view?
tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?
If you want to use the same piece of code in different jobs, how will you achieve it?
I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help
4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 please send me answer this question my mail
which is the most complex job in your career? Please tell me answer?
how do u capture duplicates through sort & transformer