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?

Answer Posted / bala

Primary Key for the dimension table is its own primary Key
PRimary Key for Fact table is Foriegn key which dirived from
Dimensional table

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have a few records just I want to store data in to targets cycling way how?

1896


How to implement complex jobs in data stage?

612


In Datastage, how you can fix the truncated data error?

640


Define Job control?

675


What is orabulk stage?

630






Describe stream connector?

832


Define data aggregation?

664


Does datastage support slowly changing dimensions ?

659


What is the difference between server job and parallel jobs?

663


What is the difference between operational data stage (ods) and data warehouse?

669


What are the some differences between 7.x and 8.x version of datastage?

737


Which commands are used to import and export the datastage jobs?

978


Have you used Unstructured data?

830


hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1463


Why do you need stage variables?

658