Answer Posted / disney
In dataset stage, Input tab of partitioning --> used the key
partition instead of auto partition , then check the
perform sort and check the unique, It will remove the
duplicate from dataset
| Is This Answer Correct ? | 25 Yes | 0 No |
Post New Answer View All Answers
AGGREGATOR default datatype
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What are the main differences you have observed between 7.x and 8.x version of datastage?
Define Job control?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What are the types of views in datastage director?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Explain the datastage parallel extender (px) or enterprise edition (ee)?
Describe the architecture of datastage?
What is a quality stage in datastage tool?
What is apt_config in datastage?
What is the difference between account and directory options ?
table actions available in oracle connector?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
