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 |
What is the difference between informatica and datastage?
How do you start developing a datastage project?
how many types of remove the duplicate records?
Triggers,VIEW,Procedures
How can we do null handling in sequential files?
How many input links can you give to a Transformer stage?
How do u convert the columns to rows in datastage?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?
Can you implement SCD2 using join, transformer and funnel stage?
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...
WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD