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
- 15261 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 are stage variables and constants?
What are the differences between datastage and informatica?
Can you explain repository tables in datastage?
what is the difference between == and eq in UNIX shell scripting?
How to Remove Duplicate using SQL?
Define repository tables in datastage?
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
How do you schedule or monitoring the job?
I have a few records just I want to store data in to targets cycling way how?
How to read multiple files using a single datastage job if files have the same metadata?
Differentiate between data file and descriptor file?
How many types of sorting methods are available in datastage?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
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?
How to implement complex jobs in data stage?
