how to retrive the max(sal),deptno,empno in datastage?
Answer Posted / nagaraju k
first take oracle->aggregator->lookup->dataset
next take 2oracle stages and then take join stage join to connect lookup stage then success fully answre will come
Any doubt means call me
+960022516
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Notification Activity
Define orabulk and bcp stages?
how can we create rank using datastage?what is the meaning of rank?
Explain the importance of surrogate key in data warehousing?
What is staging variable?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Define ds designer?
Describe the main features of datastage?
What is job control?
On which Dimension Table you implemented SCD Type in your Project
How we can covert server job to a parallel job?
Differentiate between odbc and drs stage?
What is process model?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE