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
- 12716 Views
- TCS, I also Faced
- E-Mail Answers
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 constraints and derivations?
Terminate Activity
In Datastage, how you can fix the truncated data error?
What are stage variables, derivations and constants?
how to add a new records into source?
Differentiate between hash file and sequential file?
Define APT_CONFIG in Datastage?
Differentiate between operational datastage (ods) and data warehouse?
What are the types of containers?
What is difference between symmetric multiprocessing and massive parallel processing?
What are the different types of lookups in datastage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
how to export or import the jobs in .ISX file
What are the main differences you have observed between 7.x and 8.x version of datastage?
What are the partitioning techniques available in link partitioner?
