Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 6827 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???
How to Convert the columns into rows?
What is orabulk stage?
How one source columns or rows to be loaded in to two different tables?
Difference in the implementation of lookup and join stages,in joining two tables?
difference between server shared container and parallel shared container
Differentiate between datastage and datastage tx?
what is .dsx files
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 U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?
WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?
I am running a job with 1000 records.. If the job gots aborted after loading 400 records into target... In this case i want to load the records in the target with 401 record... How will we do it??? This scenario is not for sequence job it's only in the job Ex: Seq file--> Trans--> Dataset..
9 Answers Cognizant, IBM, TCS, Virtusa,
Teradata 
