accesing hashfile -doubt
Moderators: chulett, rschirm, roy
accesing hashfile -doubt
Hi,
I have a job where i need to access a hashfile as lookup.
Will there be any affect when we access a hashfile created on dev project from testing project.Both dev and test projects are on same server.
I'm trying to load 3 lakh records to hash file.
Please let me know.
Thanks in advance!
I have a job where i need to access a hashfile as lookup.
Will there be any affect when we access a hashfile created on dev project from testing project.Both dev and test projects are on same server.
I'm trying to load 3 lakh records to hash file.
Please let me know.
Thanks in advance!
sravanthi
Re: accesing hashfile -doubt
How does your team promote jobs from DEV to TEST and then to PROD environments?
gateleys
-
- Premium Member
- Posts: 14
- Joined: Wed Feb 01, 2006 8:50 am
- Contact:
There will not be any performance issue if you load the hashed file in DEV and access from TEST. For Datastage only PATH & privileges to access the file matters ( It may be from DEV, TEST or PROD).
BUT
Better/Standard practice is
1. To make a "/test" directory in server.
2. Then run the job which creates hashed file from test environment
3. Use the hashed file form test environment.
BUT
Better/Standard practice is
1. To make a "/test" directory in server.
2. Then run the job which creates hashed file from test environment
3. Use the hashed file form test environment.
Harish vardhan
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Of course. I'm concerned about your hashed files, not your file files. My point is your assertion that the jobs are using account based (not pathed) hashed files in the dev project account. I can only see this continuing to work if your Production project is on the same server as everything else and even then it's not a very good idea. So you must be doing something else, or passing in a job parameter to use as the account name. If you've selected the option but not supplied an account name, then it is using the current account for hashed file storage. So while you may be using 'dev files' to populate them, you are using test hashed files.sravanthi wrote:Chulett..in production we are using production files.
Just trying to understand.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: