i having source like emptable,dept table and combined
purpose using for the join stage but join stage which
partition techq will be prefored?
pls given the ans?
Answer Posted / upputuri.vinod
DUDE JOIN STAGE USES THE HASH PARTITION STAGE..
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Explain datastage architecture?
How you Implemented SCD Type 1 & Type 2 in your project?
I have a few records just I want to store data in to targets cycling way how?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
How to clean the datastage repository?
What are the main features of datastage?
Differentiate between data file and descriptor file?
Define orabulk and bcp stages?
Differentiate between datastage and informatica?
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
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)
What is the command line function to import and export the ds jobs?
Difference between sequential file and data set?
How many Key we can define in remove duplicate stage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara