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
Lookup constraints
What are stage variables, derivations and constants?
Differentiate between odbc and drs stage?
what is use of SDR function?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Triggers,VIEW,Procedures
What is a ds designer?
How can we improve the performance in datastage?
client know skid info?
What is the use of datastage designer?
Can you highlight the main features of ibm infosphere information server?
Demonstrate experience in maintaining quality process standards?
Give an idea of system variables.
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?