if we take 2 tables(like emp and dept), we use join stage and
how to improve the performance?
Answer Posted / ashok
above answer has one mistake
i.e join doesn't has sort operation bydefault we explicitly
specify
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
Why do we use link partitioner and link collector in datastage?
What is job control?
Where the datastage stored his repository?
What are the functionalities of link partitioner and link collector?
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.
what is the custome stage in datastage? how can we impliment that one? plz tell me
how to abort the job its matain duplicates?
What are the types of containers and how to create them?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What is oci?
Which commands are used to import and export the datastage jobs?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Nls stands for what in datastage?
What is the differentiate between data file and descriptor file?
How a source file is populated?