Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Differentiate between operational datastage (ods) and data warehouse?

1179


What could be a data source system?

1011


how to run a sequential file stage in parallel if the stage is used on the TARGET side

1746


What is the use of datastage director?

1017


Is possible to create skid in dim,fact tables?

2637


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

1538


Can you explain kafka connector?

1312


How do you reject records in a transformer?

1125


explain about citrix scheduling tool in datastage

2457


Define APT_CONFIG in Datastage?

1080


Where do the datastage jobs get stored?

1218


How to read the length of word in unix?

1380


which r the connectors used in san?

2188


What are the benefits of datastage?

1238


Which warehouse using in your datawarehouse

2185