-
What is project life cycle and how do you implement it?
bakshtheking
- Jun 17th, 2008
Project life cycle is related to SDLCthat is software development life cycle....which mean there are 4 stages involvedthat is 1)Analysis2)development3)Testing4)ImplementationThis covers the entire project life cycle !
-
What is difference between serverjobs & paraller jobs
bakshtheking
- Jun 16th, 2008
--- Server generates DataStage BASIC, parallel generates Orchestrate shell script (osh) and C++, mainframe generates COBOL and JCL. --- In server and mainframe you tend to do most of the work in Trans...
Sharanu Patil
- Feb 28th, 2006
Server jobs can be run on SMP,MPP machines.Here performance is low i.e speed is lessParallel jobs can be run only on cluster machines .Here performance is high i.e speed is high
-
DataStage Engine Commands
I am eager to know about DataStage Engine commands. Can someone tell me something about that?
prasanth37
- Jun 12th, 2008
The following commands can be taken as DS Engine commands, used to start and stop the DS EngineDSHOME/bin/uv -admin -startDSHOME/bin/uv -admin -stop
HemaDS
- May 29th, 2008
According to me, Datastage Engine command is otherwise called as Universe Commands. It is used to retrieve the details that are stored in the datstage repository in the form of files and tables. We ca...
-
What Happens if RCP is disable ?
AjaysKumar
- Jun 4th, 2008
Then you have to manually enter all the column description in each stage.RCP- Runtime column propagation
Venkata Maruthi
- Nov 10th, 2005
Runtime column propagation (RCP): If RCP is enabled for any job, and specifically for those stage whose output connects to the shared container input, then meta data will be propagated at run time, so...
-
What is the difference between sequential file and a dataset? When to use the copy stage?
kirupakaran
- Dec 12th, 2006
hi allsequential file:it act as a source & permanent storage for target.it 's extend is .txt.dataset:it act as a temporary storage stage ,mainly it used before the target stage while using this st...
-
While using oracle database as target or Source why we will use OCI stage why don't we use ODBC stage?
sudhakar.netha
- May 29th, 2008
The reason is performance,OCI stage is faster while dealing with bulkdata and where it comes to ODBC stage its slow.But one thing ther is no rule that we Should use only OCI stage while dealing with oracle database.
pumabhanu
- Apr 19th, 2007
While using Oracle?Database as source we use oracle enterprise stage,?because it retrieves bulk of data fastly, where as the odbc stage?has drivers and are slow while retreving bulk of data.
-
How do you remove duplicate records from a file and capture the rejected records in a separate file.
nagoosk
- May 29th, 2008
sort the records using the key field.In sort stage put "key change column = true".Then zero will be assigned to the duplicate records.then put a condition as which is record is zero then send it to reject link
nagoosk
- Jan 17th, 2008
we can remove duplicate records by specifying the one of the column in target stage as key column
-
How to enable the runtime column propagation in the datastage?Where does this option exists?
nagoosk
- May 29th, 2008
It is available in 3 places1)When u open the ds Administrator ; there open any project properties;there u can see the Runtime Column Propagation.2) If u open the job properties there u can see th...
sarita
- Dec 11th, 2006
There is an option in data stage administrator->projects tab->properties button->general tab-> enable runtime column propogation for parallel jobs. If you enable this, you can select runti...
-
-
How can I specify a filter command for processing data while defining sequential file output data?
bmdirshad
- May 19th, 2008
when u open sequential file to editin general tab u have the an check box option - stage uses filter command selec this.and then go for required page(inputs/outputs)you will find in page's Ge...
Sreedhar
- Jan 30th, 2006
We have some thing called as after job subroutine and Before subroutine, with then we can execute the Unix commands. Here we can use the sort sommand or the filter cdommand
-
It is possible to run parallel jobs in server jobs?
bmdirshad
- May 16th, 2008
No, U cannot run parallel jobs in serverbut u can run parallel jobs AS server jobs, my changing APt_Config file and setting node = 1 or setting node map constrain with node1
server on parllel
- Apr 21st, 2006
By configuring config file
-
If a DataStage job has aborted after say 1000 records, how to continue the load from 1000th record after fixing the error?
sankarganeshvel
- May 13th, 2008
Hi ,if your job is using OCI stage as the target stage .then u can do it. just specify the no of the record in the Transaction handling of the OCI stage . So if the job get aborted after 1000 records ,say some 1220 then 1000 record will be there in the target table
nagoosk
- Apr 22nd, 2008
It is possible to restart the job after the aborted rows.You have to select the "check point" property in the sequence.There you have to give the aborted final record number.This is only in datastage(PX)
-
How to run a Shell Script within the scope of a Data stage job?
By using "ExcecSH" command at Before/After job properties.
vijay
- Nov 3rd, 2007
Select the EDIT tab in the toolbar-> choose job properties-> select the job parameters->choose the Before/ After routines ->select the EXCESH command
-
Abort a job after loading 10 records
How to implement in datastgae like the job should abort after it loads 10 records into the target using lookup?
nagoosk
- Apr 29th, 2008
You can abort a job after n records which is available while you r running the job you can see tha option as "abort job after _____" . there you can specify the number
-
MQ Series
Why and where and how is MQ series stage used in datastage?
-
Is Hashed file an Active or Passive Stage? When will be it useful?
vasanthsolai
- Apr 17th, 2008
Hash file is passive stage,it wil be used in lookup,the hash file using hahing algorithm and reterive the data faster...
wahi80
- Feb 20th, 2008
Has files is a passive stage. In DS Server edition hash files are used in jobs where lookups are required. Hash files are generally used in intermediate jobs in DS, where there is a need tostore data in anintermediate table format
-
How we use NLS function in Datastage? what are advantages of NLS function? where we can use that one? explain briefly?
vasanthsolai
- Apr 17th, 2008
NLS=NATIONAL LANGUAGE SUPPORT,it is used to sort the data,and give the data to users to local formatt.....
Aravind
- Dec 23rd, 2005
By using NLS function we can do the following - Process the data in a wide range of languages ...
-
Hi all what is auditstage,profilestage,qulaitystages in datastge please explain indetail
vasanthsolai
- Apr 15th, 2008
Profile stage is used to analyase the data and their relationship..quality stage is used to check for the quality
-
What is the difference between Transform and Routine in DataStage?
vasanthsolai
- Apr 14th, 2008
Routines are used to return the values ,transform cannot return the values
JOHN DANIEL
- Nov 8th, 2006
Transformar transform the data from one from to another form .where as Routines describes the business logic.
-
What is quality stage and profile stage?
vasanthsolai
- Apr 14th, 2008
Quality stage is used for check the quality..profle stage is used to anaylse the data and their relationship
Abhijain
- Feb 20th, 2008
Quality stage is a data integration tool from ascential which is used to stadardize/integrate the data from different sources.
DataStage Interview Questions
Ans