-
How can we generate a surrogate key in server/parallel jobs?
narra satish
- Mar 28th, 2011
Hi,By using transformer we can generate the servgate key.In stagevariablesand write the derviation.
neeraj82
- Jul 3rd, 2009
You can generate through system variable in transformer which is built-in name is keymgt. You don't have remember full name and in parallel you can generate through surrogate key generator.
-
Reading multiple files through sequential file
What are the ways to read multiiple files from sequentila file if the both files are differnt
-
Change File Attribute
How to change the attribute of a .dsx format file to make it read only?
narra satish
- Mar 7th, 2011
First import the job in .dsxformat and change the attributes ther 0-Editable1-Read onlyAnd import again and override it.
-
Explain about Error Handling in Datastage and best practices.
madhavsandireddi
- Feb 25th, 2011
In sequence job we have to run a job and if a job is aborted and if we do not have terminator activity then control goes to the exception handler where it checks for what reason the job is aborted..ThanksMadhav
nikhilanshuman
- Dec 29th, 2009
In datastage sequence,there is "Exception Handler" activity.When you are calling your jobs from a Datastage Sequence you should do following :Step 1: Go to properties of master sequence and ...
-
What is the exact difference b/w LOOKUP stage , JOIN stage and MERGE stage?
madhavsandireddi
- Feb 24th, 2011
The major difference between LKP stage, Join stage, merge stage are LKP & JOIN: If the reference data in the LKP stage is huge when compared to the primary data. there is no reject requiremen...
Pavan Batchu
- Nov 12th, 2007
Lookup stage: 1.Can only return multiple matching rows from one reference.2. Can reject rows based on constraint.3. Can set failure.4. Does not need partitioned and sorted input. Merge stage: 1. Can...
-
Passing parameters from one job to another job using command prompt
How can we pass parameters from one job to another job by using command line prompt?plz send ans... thanks in advance.Alam
cevvavijay
- Feb 10th, 2011
We can pass parameter to a job using two ways .. using dsjob- command line or from a sequencer.Other way would be -You configure single parameter set ( version 8.0 onwards) and use the same in both th...
-
How to Create new user in Datastage 7.5
I want to create new user in datastage 7.5 I dont know how to do it?
manoj kumar ganji
- Jan 23rd, 2011
User creation in 7.5 is os dependant i.e.., you can make creation of users in OS. For example when you load DS on Windows XP, then create new user in user accounts in control panel.
tisha24
- Dec 13th, 2010
The user created in and for windows will be a user for datastage by default..You can't crete a user from datastage environment. If you want to create a user create through Control panel user.. The...
-
Job Unlock
How to unlock a job in Datastage 8.0?
sivakumar.datastagepx
- Jan 19th, 2011
$ps -EF$kill PIDBy using above 2 commands in unix ...then we can kill the jobotherwise tools-> cleanup resourses
svasu.r
- Aug 14th, 2010
If you want unlock the jobDS DIRECTOR----------->JOB TAB-------->Clean up on resourcesIn admin enable priviliges to director
-
OCI Stage
Why array list is used in Oracle OCI stage? Brief about Important Options in OCI Stage.
Mili Jon
- Jan 16th, 2011
Array size is a property of OCI stage which help to reduce the context switch between DataStage and Oracle database. We should keep this in mind that however it help us reducing the context switch but...
DSQuest
- May 7th, 2010
I Suppose it is called "Array Size"....Array Size is mainly used to increase the buffer during Write operations into a Oracle DB in a Server job using the Oracle OCI stage.This comes of grea...
-
What happens if the job fails at night?
Mili Jon
- Jan 16th, 2011
Job aborts and logs can be seen on Director client. However a notification can be set using the notification Stage to send emails during failure.
gagan8877
- May 8th, 2007
U can define a job sequence to send an email using SMTP activity if the job fails. Or log the failure to a log file using DSlogfatal/DSLogEvent from controlling job or using a After Job Routine. orUse dsJob -log from CLI.
-
Orchestrate Schema
What is Orchestrate Schema? Distinguish internal data type (Orchestrate schema) vs external data type
nikhilanshuman
- Dec 25th, 2010
Orchestrate schema defines the fields and their datatypes.There are two types of Orchestarte shcemas a) Input Schems b)Output schema.Orchestrate Schema can be compared with "STRUCT" of C.Example : RollNo - int32
-
Tell me one situation from your last project, where you had faced problem and How did u solve it?
A. The jobs in which data is read directly from OCI stages are running extremely slow. I had to stage the data before sending to the transformer to make the jobs run faster.B. The job aborts in the middle of loading some 500,000 rows. Have an option either cleaning/deleting the loaded data and then run the fixed job or run the job again from the row the job has aborted. To make sure the load...
nikhilanshuman
- Dec 18th, 2010
a) We had a big job with around 40 stages.The job was taking too long tocompile and run.We broke the job into 3 smaller jobs.After this ,we observed that the performance was slighly improved and maint...
-
When should we use ODS?
DWH's are typically read only, batch updated on a scheduleODS's are maintained in more real time, trickle fed constantly
nikhilanshuman
- Dec 19th, 2010
An opearation data store contains the data which are constantly updated through the course of the business operations. ODS is specially designed such that it can quickly perform relatively simply que...
-
DSParams file
Is it like that if we define the values of variables in DSParams file then there is no need to give the values at job level ar Project level ?& how to configure this file at job level ?so that we need not hardcode the values.....
nikhilanshuman
- Dec 19th, 2010
yes.DSParams file contains all the project level parameters which are set up in Datastage Administrator.If the values are provided/modified in this file,the changes are automatically reflected in the ...
-
How can we load the flat file
How can i load a flat file into target as fast as i can?Assuming that the source bottleneck is not there,that is there is no performance issues in the source side.
nikhilanshuman
- Dec 18th, 2010
A Flat file can be read using sequential file stage.To make data load faster,try implementing least stages in you job and use minimal transformations.if you are trying to load the data of a flat file ...
-
Does the BibhudataStage Oracle plug-in better than OCI plug-in coming from DataStage? What is the BibhudataStage extra functions?
nikhilanshuman
- Dec 18th, 2010
There is no such thing like "BibhudataStage Oracle plug-in" in Datastage.The question seems to be wrong.
-
Hican any one can explain what areDB2 UDB utilitiesub
nikhilanshuman
- Dec 18th, 2010
"DB2 UDB" is a stage in Datastage using which the connectivity could be made to DB2 databases.It could be used to fetch the data from DB2 databases or to perform DML operations in DB2(e.g. Insert/update) or Bulk load etc..
-
A batch is running and it is scheduled to run in 5 minutes. But after 10 days the time changes to 10 minutes. What type of error is this and how to fix it?
nikhilanshuman
- Dec 18th, 2010
If the batch is taking more time to execute(10 mins),it may be due to the performance issues.In such cases the performance optimizstion mesures should be taken.If without making any changes,time taken...
-
Does type of partitioning change for SMP and MPP systems?
nikhilanshuman
- Dec 18th, 2010
Datastage is platform independent.A same job,when designed properly can run on SMP as well as MPP systems.Partitioning does not need to be changed for SMP/MPP systems.
-
What is trouble shhoting in server jobs ? what are the diff kinds of errors encountered while running any job?
nikhilanshuman
- Dec 18th, 2010
Troubleshooting in datastage server jobs involves monitoring the job log for fatal errors and taking appropriate actions to resolve them.There can be various errors which could be encountered while ru...
DataStage Interview Questions
Ans