how many dimentions and fact tables used in your project and
what are names of it?
Answers were Sorted based on User's Feedback
Answer / raj
Product Dimension : Product Key, Product id, Product Type, Product name, Batch Number.
Distributor Dimension: Distributor key, Distributor Id, Distributor Location,
Customer Dimension : Customer Key, Customer Id, CName, Age, status, Address, Contact
Account Dimension : Account Key, Acct id, acct type, Location, Balance
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / archana
hi raj,
where is the fact tables,can u tell me the fact tables desc also.thanks in advance
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / avinash(datastage proff)
anybody knows it pls send rep fast
| Is This Answer Correct ? | 3 Yes | 6 No |
Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.
create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid salary previoussalary 10 1000 null 20 2000 1000 30 3000 2000 40 4000 3000
Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?
how can u find out the datastage job is running on how many nodes
Explain the functionality of your current project?
1 Answers IBM, Miles Software,
Which warehouse using in your datawarehouse
What are some prerequisites for datastage?
when u face critical situation in ur project, how to solve them?
What are the types of containers and how to create them?
hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
How to Convert a string function to date function by using only sequential file stage with out using other stages ?