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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2004


How do you import and export data into datastage?

695


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

556


What are the components of datastage?

646


What are the various kinds of the hash file?

657






How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1076


What is the roundrobin collector?

635


Differentiate between hash file and sequential file?

576


Terminate Activity

835


What are the types of containers?

680


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3263


Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

343


What is the difference between in process and inter process?

663


Why do we use link partitioner and link collector in datastage?

679


im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

1627