It is possible to access the same job two users at a time in datastage? - No, it is not possible to access the same job two users at the same time. DS will produce the following error : "Job is accessed by other user" - DataStage Interview Questions and Answers

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

DATA WAREHOUSING

DATASTAGE

DETAILS

Question: It is possible to access the same job two users at a time in datastage?

Answer: No, it is not possible to access the same job two users at the same time. DS will produce the following error : "Job is accessed by other user"

Category	DataStage Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 8521 users
Added on	7/26/2011
Views	71748
Rate it!

Question: It is possible to access the same job two users at a time in datastage?

Answer:

No, it is not possible to access the same job two users at the same time. DS will produce the following error : "Job is accessed by other user"

Source: CoolInterview.com

No it is not possible for the same job to be accessed by two users, because if one of the job is being used by one user then if the second one tries to open the same job then you get the error as "Job (jobname) is being accessed by another user" Source: CoolInterview.com

Answered by: Santosh Mittapelli | Date: 3/12/2009 |

Contact Santosh Mittapelli

In Datastage 8 it is possible to open the job as Read-Only.In order to do some modification in the read-only job,take a copy of the job as modification cannot be done in a read only job.This feature is not available in Datastage 7.5. Source: CoolInterview.com

Answered by: ethelvina | Date: 8/1/2009 |

Contact ethelvina

On the access front i second ethelvina and if the same job has to be run by two different users at a time it is possible provided the job is a multiple instance job and both the users invoke the job with different instance IDs. Source: CoolInterview.com

Answered by: Pavan | Date: 2/12/2010 |

Contact Pavan

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	If the size of the Hash file exceeds 2GB..What happens? Does it overwrite the current rows?	View Answer
	How to drop the index befor loading data in target and how to rebuild it in data stage?	View Answer
	How to parametarise a field in a sequential file?I am using Datastage as ETL Tool,Sequential file as source.	View Answer
	How to kill the job in data stage?	View Answer
	Where we use link partitioner in data stage job?explain with example?	View Answer
	What is the difference between sequential file and a dataset? When to use the copy stage?	View Answer
	What is the purpose of exception activity in data stage 7.5?	View Answer
	How i create datastage Engine stop start script. Actually my idea is as below. !#bin/bash dsadm - user su - root password (encript) DSHOMEBIN=/Ascential/DataStage/home/dsadm/Ascential/DataStage/DSEngine/bin if check ps -ef \| grep DataStage (client connection is there) { kill -9 PID (client connection) } uv -admin - stop > dev/null uv -admin - start > dev/null verify process check the connection echo "Started properly"	View Answer
	What does separation option in static hash-file mean?	View Answer
	What is the difference between Symetrically parallel processing,Massively parallel processing?	View Answer
	How to implement slowly changing dimentions in Datastage?	View Answer
	How to improve the performance of hash file?	View Answer
	My requirement is like this : Here is the codification suggested: SALE_HEADER_XXXXX_YYYYMMDD.PSV SALE_LINE_XXXXX_YYYYMMDD.PSV XXXXX = LVM sequence to ensure unicity and continuity of file exchanges Caution, there will an increment to implement. YYYYMMDD = LVM date of file creation COMPRESSION AND DELIVERY TO: SALE_HEADER_XXXXX_YYYYMMDD.ZIP AND SALE_LINE_XXXXX_YYYYMMDD.ZIP if we run that job the target file names are like this sale_header_1_20060206 & sale_line_1_20060206. If we run next time means the target files we like this sale_header_2_20060206 & sale_line_2_20060206. If we run the same in next day means the target files we want like this sale_header_3_20060306 & sale_line_3_20060306. i.e., whenever we run the same job the target files automatically changes its filename to filename_increment to previous number(previousnumber + 1)_currentdate; Please do needful by repling this question..	View Answer
	What is the transaction size and array size in OCI stage?how these can be used?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All DataStage Interview Questions & Answers - Exam Mode / Learning Mode