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
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|
Can you filter data in hashed file?
Define APT_CONFIG in Datastage?
What is active and passive stage?
Why fact table is in normal form?
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?
How do y read Sequential file from job control?
3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000
1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
How to clean the datastage repository?
On which Dimension Table you implemented SCD Type in your Project
souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2