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 / subhash
executing the sql query through unix:
sqlplus -s <userName>/<passWord>@<HostName> <<EOF >
testData.txt
set pagesize 0
select sysdate from dual;
EOF
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are the different common services in datastage?
What are the functionalities of link partitioner?
what is repositery?
What are stage variables?
What are the benefits of datastage?
What are the processing stages?
How many types of stage?
What is the command line function to import and export the ds jobs?
What are the main features of datastage?
What are routines in datastage? Enlist various types of routines.
What is the difference between an operational datastage and a data warehouse?
Explain the situation where you have applied SCD in your project?
What are datastage sequences?
how many rows sorted in sort stage by default in server jobs
Differentiate between data file and descriptor file?