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 / 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 |
Post New Answer View All Answers
What are the differences between datastage and informatica?
What is the difference between an operational datastage and a data warehouse?
Is possible to create skid in dim,fact tables?
What is datastage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
How to RD using transformer?
What is oci?
Could anyone give brief explanation bout datastage admin
which r the connectors used in san?
How one source columns or rows to be loaded in to two different tables?
How we can covert server job to a parallel job?
Describe the architecture of datastage?
What are the different options associated with dsjob command?