Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


how many dimentions and fact tables used in your project and
what are names of it?

Answers were Sorted based on User's Feedback



how many dimentions and fact tables used in your project and what are names of it?..

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

how many dimentions and fact tables used in your project and what are names of it?..

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

how many dimentions and fact tables used in your project and what are names of it?..

Answer / avinash(datastage proff)

anybody knows it pls send rep fast

Is This Answer Correct ?    3 Yes 6 No

Post New Answer

More Data Stage Interview Questions

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.

2 Answers   IBM,


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

5 Answers   Genpact,


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?

7 Answers   IBM,


how can u find out the datastage job is running on how many nodes

7 Answers   IBM,


Explain the functionality of your current project?

1 Answers   IBM, Miles Software,


Which warehouse using in your datawarehouse

0 Answers   IBM,


What are some prerequisites for datastage?

0 Answers  


when u face critical situation in ur project, how to solve them?

1 Answers   Toyota,


What are the types of containers and how to create them?

0 Answers  


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 Answers   Wipro,


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 ?

0 Answers   Wipro,


How to Convert a string function to date function by using only sequential file stage with out using other stages ?

5 Answers   TCS,


Categories