-
Nodes Types
What are the types of nodes in datastage?
nikhilanshuman
- Dec 9th, 2010
The degree of parallellism of parallel jobs depends on the number of nodes you define in your configuration file.Nodes are just the logically created processes by the OS.basically two types of nodes e...
-
Aggregator Stage Hash Partition
How will the performance improve by using Hash partition in Aggregator stage?
tisha24
- Aug 4th, 2010
As we know,In HASH partition, data with same key column/columns are moved to one partition for processing.aggregation is done with grouping on key column. So with Hash partio...
-
Dataset Parallel Jobs Performance
Will the performance improve by using dataset in parallel jobs? How?
tisha24
- Aug 5th, 2010
Yes. Since the datasets are internal storage file format for datastage and build using orchestrate scripts,the specific scripts for datastage. So the dataset can be processed with out any transcoding and hence very faster.
-
Datastage Parallel Jobs Performance
How will the performance affect if we use more number of Transformer stages in Datastage parallel jobs?
nikhilanshuman
- Dec 9th, 2010
Transformer stages compile in C++ whereas other stages compile into OSH (Orchestarte scripting language.).If number of transfomers are more,first thing is the compilation time will be impacted.it will...
-
Convert Date in Modify Stage
How to convert date format from dd/mm/yyyy to yyyy/mm/dd in modify stage?
Brajesh Singh Bhadoriya
- Sep 25th, 2010
To convert date from DD/MM/YYYY to YYYY/MM/DD, first we have to change the default date format in the job. Follow below steps:1. Go to job property. Go to Defaults tab. There un-check the option for d...
-
DataStage Job Scheduling
How to schedule a datastage job using cron tab utility?
nikhilanshuman
- Dec 9th, 2010
The datastage jobs can be scheduled by using following steps:a) Write a script say runjob.sh to call the datastage job/sequence.The shell script calls the datastage job by making use of "dsjob -r...
-
Datastage Lookup
By using lookup we join the data from more than one table, we can implement the same using join stage, then what is the need of Lookup stage especially in Datastage?
nikhilanshuman
- Dec 9th, 2010
Datastage lookup has some additional benefits over join stage :a) A lookup stage supports reject link which is not supported by join stage.b) Lookup stage has an option to fail the job if the lookup f...
-
Sequential File Stage Duplicates
How to remove duplicates through only sequential file stage?
Brajesh Singh Bhadoriya
- Sep 25th, 2010
To remove duplicates from a sequential file, use filter property of sequential file stage. Put "sort | uniq" in filter and it will remove duplicates from file and in output it will have all unique records.Hope this helps.
-
Calculation Without using Aggregator
How to calculate Sum, Averages, Minimum, Maximum salaries of an employee without using Aggregator stage in datastage?
-
Flatfiles Validations
When we are extracting the flatfiles, What are the basic required validations?
nikhilanshuman
- Dec 9th, 2010
Folllowing are some common validations performed:a) Check for blank lines and remove them.b) Check the number of column in each row of the file.c) If there is a? trailer line in the flat file contain...
-
-
Datastage versions difference
What is the difference between datastage 7.1 & 8.0.1 versions ?
shyam.kandi99
- Nov 9th, 2010
Diff B/W Data Stage version 7.5 and Version 8.0I ) in 7.5 >> 4 client components in 8.0 5Client ComponentsDS Designer Web ConsoleDS Director Information AnalyzerDS Manager DS DesignerDS Administ...
-
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...
-
Flat File as Source
How to extract your flat files using sequntial file or dataset? From where to get these flat files as source?
-
What happens if we run 7.5 vesion job in 8 version
What happens if we run 7.5 vesion job in 8 version? what is the error?
-
How to improve the performance while reading data through sequentilal file?
tapan8984
- Aug 12th, 2011
We can use the Number of readers per Node property to enhance parallelism in Sequential file, hence enhancing the performance..
-
How to run 10 jobs at the same time in DataStage 8.0.1?
j.padma89
- Jul 14th, 2011
To run 10 or any number of jobs one after the other or in any sequence, One can use "job sequences".
In each sequence one can assign a job, so after the 10 sequences , you can run a sequence job.
Using sequential jobs developer can even decide what should a job do if it is aborted.
amulas
- Jul 13th, 2011
By using multiple job compile from ds director, we can run multiple jobs at a time.....
-
-
How to configure ODBC drivers to work with Data stage ?
SinhaS
- Aug 4th, 2011
1) First check that the Driver has been installed and the library env variable has been set correctly to point to it by the UNIX admin who installed it ($LD_LIBRARY_PATH). 2) Go to $DSHOME and update ...
-
Ways of implementing scd2
How many number of ways that you can implement SCD2 ? Explain them
DataStage Interview Questions
Ans