if we take 2 tables(like emp and dept), we use join stage and
how to improve the performance?
Answer Posted / rajeshchunduri
in emp and dept tables key column is deptno so it is key
based and datatype for key column is int . At this time we
change partion tech from hash to modulus.
chunduri
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Differentiate between operational datastage (ods) and data warehouse?
What could be a data source system?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What is the use of datastage director?
Is possible to create skid in dim,fact tables?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Can you explain kafka connector?
How do you reject records in a transformer?
explain about citrix scheduling tool in datastage
Define APT_CONFIG in Datastage?
Where do the datastage jobs get stored?
How to read the length of word in unix?
which r the connectors used in san?
What are the benefits of datastage?
Which warehouse using in your datawarehouse