-
Retrieve Hash File
How to retrieve hash file data from administrator command?
nikhilanshuman
- Mar 17th, 2010
Open datastage administrator.Select your project.On the right hand side,you will see "Command" button.Click on it.You will get a command interface window.Here you can write select queries to...
-
Datastage Parallel Process
How do you make a simple job which reads data from Oracle database and write into a sequential file run in parallel?Since reading of data from database is sequential and sequential file also works sequentially.
nikhilanshuman
- Mar 16th, 2010
In OCI stage,there is the option called "Partition Table".Using this option,you can make the OCI stage read the data in parallel.The option is available in -Output -> Properties ->Source
-
Can we pass the parameters in job sequence
nikhilanshuman
- Mar 10th, 2010
Parameters can be passed to the job sequence using a shell script.Following is the command to run the sequence with passing the parameters :dsjob -run mode Normal -param param=value projectname S...
nikhilanshuman
- Dec 25th, 2009
Please provide more details.=> Are you asking to pass the parameters to the job sequence from any external script?=> Are you asking passing parameters to a parallel job from sequence?
-
Fileset
What for exactly fileset is used?
nikhilanshuman
- Mar 10th, 2010
A Fileset can be used to store records(Just like a dataset or sequential file but,the way of storing records is different in filesets,datasets and sequential files.)
-
Job Sequences with Restart Ability
How to do job sequences with restart ability?
nikhilanshuman
- Mar 10th, 2010
It seems you are asking about resuming the job sequence from failure point if it is aborted.In order to do so,open the sequence.Now go to "job properties" and check the checkbox "Add checkpoints so sequence is restartable on failure."
-
What is the utility you use to schedule the jobs on a UNIX server other than using Ascential Director?
Use crontab utility along with dsexecute() function along with proper parameters passed.
SudhirKanojia
- Feb 10th, 2010
You can call?the job in the UNIX shell script & schedule the script into the crontab file.Regrads:Sudhir Kanojia
RamaPrasad Batchu
- Mar 8th, 2006
"Control_M Scheduling Tool": Thru Control_M u can automate the job by invoking the shell script written to schedule the datastage jobs.
-
What is the necessity to run the datastage job in Unix background?
SudhirKanojia
- Feb 9th, 2010
We need to execute dsenv file, before executing DataSatge job in UNIX background using DsRunJob commandRegard Sudhir Kanojia
veer.dwh
- Sep 23rd, 2009
You can run DS jobs using DS desiner and director client components. but in real time we will have huge no of jobs and those has sequnce of order dependency? to prform client requirment. in that situ...
-
How to load the top 3 marks(column name) from seqential file to the target
SudhirKanojia
- Feb 8th, 2010
This can be achieve by sort & external filter satge.First sort the data in descending order after that use external filter stage & give UNIX command head -3 in the box.
Sathish123
- Feb 20th, 2007
First sort the data on Marks column using sort stage then use transformer stage.In constraints use system variable @INROWNUM (@INROWNUM<=3).In this way you can get top 3 marks.
-
How to remove the locked jobs using datastage?
SudhirKanojia
- Feb 8th, 2010
Login to Datasatage AdministratorGo to Properties ->go to commandtype LIST.READUYou will find the PID(inode) along with job name in tabular format.Find the job which is lockedthen typeUNLOCK INODE (Inode no xxxxxx) ALLRegardSudhir Kanojia
parvathi
- Oct 8th, 2007
Also find out the PID number from datastage director in cleanup resources link and go to the UNIX server and kill PID number. This way you can easily kill the process and it gets unlocked.
-
Job Schedule
How to schedule jobs in UNIX Server?
Abhijain
- Feb 8th, 2010
Couple of ways to schedule the Datastage jobs/sequences-1. Can be done using Datastage Director Tool 2. Normally done using crontab script. You can easily get it through google.3. Can use Third party scheduling tools like Autosys
veer.dwh
- Jul 20th, 2009
DataStage job scheduling we can do using datastage director client tool, but in real time they use UNIX for DataStage job scheduling which supports 3rd party scheduling tools like Autosys, Triviam, UNIX corn tab etc.
-
Incremental Loading
How to do incremental loading in datastage?
Abhijain
- Feb 8th, 2010
This question is been answered many times before. Do go through the link below--http://www.geekinterview.com/question_details/77425
-
Job Sequence
How to create Job Sequence?
Abhijain
- Feb 8th, 2010
Have you ever tried opening Datastage and browse all the available options.To create a job sequence. Below are the steps;1. Open Datastage2. Open New Job Sequence3. Save it with some name.4. A your job sequence is created.5. Now drag the job sequence stages-->as per your business requirement.
veer.dwh
- Jul 20th, 2009
You can create job sequencer using designer client, if you click create new job like server or px job in Datastage, it will get open window there you can find to create the job sequencer.Job sequencer uses to run multiple jobs either server or px based on the dependencies.
-
Setting up of node
How do we set up nodes in Datastage?
amitarudra
- Jan 29th, 2010
We can set the nodes in the follwing path C:AscentialDataStageConfigurations, which is a text file containing { node "node1" { &nb...
john_345
- Nov 19th, 2008
Here not the question of admin or developer.For the above question we have provide proper answer, like Go to DS manager and create nodes into Configuaration file according to the requirement. Please if any of DS admin registered expecting step by step process. Mine is also not clear answer.
-
I want to process 3 files in sequentially one by one , how can i do that. while processing the files it should fetch files automatically .
bizzinsights
- Jan 29th, 2010
Append all the source files into a single file in Unix if the metadata is same. Use that file as the input for the DS job.
qwert123
- Jun 30th, 2009
Parameterize the file name.
Build the job using that parameter.
Build job sequencer which will call this job and will accept the parameter for file name.
Write a UNIX shell script which will call the job sequencer three times by passing different file each time. -
Rename Jobs
How will you rename all of the jobs to support your new File-naming conventions?
DatastageDev
- Jan 26th, 2010
More easily you can export to an XML file then simply do a find and replace. You can do this for any changes, job names, parameters, etc. Then import the jobs back to the project.
vkamatag
- Dec 8th, 2009
Create a excel spreadsheet with new and old names. Export the whole project as a .dsx. write a perl program, which can do simple rename of the strings looking looking up the excel file. Then import th...
-
Parallel Processing
How does config file help in Parallel processing?
manisha803
- Jan 20th, 2010
Configuration file provides hardware configuration for supporting such architecture as SMP, Grid or MMP (Multiple CPU, Multiple nodes and dedicated memory per node).Configuration file define all confi...
-
In which situation,we are using RUN TIME COLUMN PROPAGATION option?
pankaj.garg026
- Jan 15th, 2010
Run Time Column Propagation can be used with Column Import Stage. If RCP is enabled in our project, we can define only the columns which we are interested in and other rest of the columns datastage wi...
poonam
- Feb 14th, 2007
Run time column propagation is used in case of partial schema usage. when we only know about the columns to be processed and we want all other columns to be propagated to target as they are, we check ...
-
What is PROFILE STAGE , QUALITY STAGE,AUDIT STAGE in datastage..please expalin in detail.thanks in adv
hansth
- Jan 12th, 2010
Profile stage: is a profiling tool to investigate data sources to see inherent structures, frequencies of phrases, identify datatypes, etc.. In addition it can, based on the real data, rather than met...
-
Pass input parameters using UNIX Shell script
How to pass input parameters using UNIX Shell script to DataStage Director?
nikhilanshuman
- Dec 29th, 2009
From UNIX, Parameters are passed to datastage job while running them.This can be done by passing "-param" paramater to dsjob command.Syntax :dsjob -run mode Normal -param param1=value1 project name jobname
-
What is the use of clear status file
What is the use of clear status file in DS?How we will use it?explain with examples?
nikhilanshuman
- Dec 30th, 2009
If status is cleared for a datastage job,all of its instaces will be deleted.I mean if there is a instance say jobname.inst1 or jobname.inst2 these will be deleted.The entries for that particular jobs will be cleared from RT_Status(n) table.Here n is the job number.
ketanshah123
- Feb 19th, 2008
When you clear a job’s status file you reset the status records associated with all stages in that job. You should therefore use this option with great care, and only when you believe a job has ...
DataStage Interview Questions
Ans