Interested to Buy Any Domain ? << Click Here >> for more details...
What modeling tool do you use?
- 6 Answers
- 13710 Views
- HP, I also Faced
- E-Mail Answers
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 you explain players in datastage?
Display all files which have size more 3KB in given directory/folder.
What is the use of Row generator stage?
3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000
What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.
I have a few records all are same structures data, I want to store data in multiple targets how?
How do you load 10 different sources with 10 different layouts to 10 different tables?
How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?
how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel
Explain ibm infosphere information server and highlight its main features?
1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?
my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage
Teradata 
