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
Difference between server jobs & parallel jobs?
How do you import and export the datastage jobs?
Define Data Stage?
What is datastage engine?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Describe the architecture of datastage?
What is a quality stage in datastage tool?
What all the types of jobs you developed?
What is the difference between hashfile and sequential file?
What is orabulk stage?
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
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.
Which commands are used to import and export the datastage jobs?
Define APT_CONFIG in Datastage?
how to write server Routine coding?