Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 12317 Views
- TCS, I also Faced
- E-Mail Answers
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 flow of project?
1.What is a delta record? How you will read it? 2.What are the different types of sorting?
WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?
What is a ds designer?
Lookup constraints
What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.
How to Convert the columns into rows?
i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me
What is the use of datastage director?
What is the sortmerge collector?
AGGREGATOR default datatype
Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel suneel suneel suneel suneel how it will get. Please design job with explain. Thanks.
Teradata 
