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?
Answers were Sorted based on User's Feedback
Answer / paramita biswas
connect to sqlplus from unix
typing sqlplus
user name:user_name@database
password:
then type
@pathname of the file containing sql query\sql query file
name.sql
eg:@path\file.sql
press enter
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / 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 |
Answer / nish
how to execute SQL query through unix.
This is a generic question. You need to use the Command line utility provided by the DBMS
For oracle; SQL plus
DB2: DB2 CLI
others : as provided by the product.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / jaini
In order to execute an sql query thru unix, simply write db2 "sql query" and press enter.
Is This Answer Correct ? | 1 Yes | 2 No |
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
what r the sources u need to create the datastage?
what is parameterset?
what is .dsx files
HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?
How many types of views are there in a datastage director?
can we use sequential file as a lookup
what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?
What are stage variables, derivations and constants?
What are the various kinds of the hash file?