Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrive the max(sal),deptno,empno in datastage?
- 13 Answers
- 24887 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / srinu
select sal,deptno,empno from emp where sal=(select max(sal)
from emp);
this is write answer check that......after checking any
queries ask me..........
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Define meta stage?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
How a routine is called in datastage job?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
how to delete one row in target dataset
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Why fact table is in normal form?
Explain usage analysis in datastage?
CHANGE CAPTURE
How we can covert server job to a parallel job?
Highlight the main features of datastage?
What are stage variables, derivations and constants?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
