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?
- 5 Answers
- 15494 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / professional
Hi,
For the above query to improve the performance based on key columns in emp and dept joins by default sort in datastage for better performance if you have already a sorted data just go for environmental variables and do the operation #APT_Not_SORTDATA option then performance increase automatically...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What could be a data source system?
What is the difference between odbc and drs stage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is aggtorec restructure operator?
What is the roundrobin collector?
What are the main features of datastage?
What are the various kinds of the hash file?
How do you schedule or monitoring the job?
What is the difference between orabulk and bcp stages?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Whats difference betweeen operational data stage (ods) and data warehouse?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Name the different types of Lookups in Datastage?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
Explain connectivity between datastage with datasources?
