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?
Answers were Sorted based on User's Feedback
Answer / upputuri.vinod
DUDE JOIN STAGE USES THE HASH PARTITION STAGE..
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / san
When ever you want join the two files .. you need to do hash
partition using natural keys both sides. Otherwise the value
related keys will go into different partitions and while
join match will not occur properly.
| Is This Answer Correct ? | 2 Yes | 0 No |
Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks
while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance
what is the Difference Between Datastage Server Edition and Parallel Edition?
Lookup constraints
Highlight the main features of datastage?
What is active and passive stage?
count number of deptno in a emp table?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
job locking methods? How can we unlock the job?
I/P --- ID Value 1 AB 2 ABC 3 ADE 4 A O/p --- ID Value 1 A 1 B 2 A 2 B 2 C 3 A 3 D 3 E 4 A
How to clean the datastage repository?
What are the some differences between 7.x and 8.x version of datastage?