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 the use of invokation id
I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.
Name the command line functions to import and export the DS jobs?
IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?
what is datastage job Monitoring
how does work server jobs?
What is the difference between datastage and datastage tx?
What are the environmental settings for data stage,while working on parellel jobs?
what is hash file
j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?
can explain wt is the pool for file.
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?