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 / 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 |
Post New Answer View All Answers
How complex jobs are implemented in datstage to improve performance?
Which warehouse using in your datawarehouse
What are the processing stages?
Define Routines and their types?
What are the steps required to kill the job in Datastage?
sed,awk,head
How we can covert server job to a parallel job?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
in oracle target stage when we use load option and when we use upsert option?
Notification Activity
What are data elements?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
What are the different options associated with dsjob command?
how many rows sorted in sort stage by default in server jobs
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.