-
Datastage Job Speed
How we can increase the speed of job in datastage?
veer.dwh
- Sep 19th, 2009
To improve DS job performence we can fallow sertain techniques If it is PX job we can use pipeline or data partition techniques to run single job into multiple instance based on server configuration ...
-
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 ...
-
Datastage Standards
What are the datastage standards to be considered?
Saibal Samaddar
- May 4th, 2010
Naming conventions, especially for DataStage Project categories, stage names, and links.
-
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
-
How to work with Repeating fields in Datastage?
I am working on Datastage. Can any body tell me how to work on repeating fields and multiple headers.
bhaskar.jha
- Jul 25th, 2008
We should create some staging variable & define the value for repeating fields there & then just map these to respective columns.
-
Low Level Design
How low level design will be prepared in datastage?
devraj26e
- Feb 5th, 2009
Extraction over view (what is the size of the source file, what is the volume of each file, what?type of file it is), how to map the files from source to target, what kind of business logic we have to implement, how to conduct unit testing all these comes under low level designing.?
-
-
-
Clear logs
How to clear logs after 5 days, by using a routine?
nikhilanshuman
- Dec 25th, 2009
The logs can be cleared by deleting entries from the Universe table RT_LOGn.Here n is the job number.For this you need to go to Datastage Administrator - > Command.Here you can execute the queries on the universe tables.
-
Datastage Parallel Extender
How to extract data from source to staging area using datastage parallel extender?
nikhilanshuman
- Mar 18th, 2010
Design your job as per the requirement.If the source is a sequential file,use a sequential file stage. If the source is a table, use database stages like OCI,DRS,ODBC etc...Use a transformer to ...
-
Data Sets and File Sets
Expalin difference between Data Sets and File Sets? where each one is used and how they are used?What is the size limit?
Abhijain
- Sep 19th, 2008
The dataset and fileset both are file stage. Dataset can have single input link or single output link whereas, Fileset can have single input link or single output link and a single reject link.File se...
-
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
-
Datastage Server Outer Join Facility
How to get outer join facility from Datastage Server?
nikhilanshuman
- Mar 18th, 2010
In server jobs,you can use "Merge Stage" to perform outer joiins.In parallel job you can use Lookup stage,Join stage and Merge stage.Lookup stage and Merge stage have limitations in performing joins.E.g.-- In lookup stage,left outer join can be performed.(Also,inner join)
-
Data stage Parallel extender
What is data stage parallel extender?
veer.dwh
- Jul 20th, 2009
DataStage jobs are classified into 3 types1.Server job2.Parallel job3.Mainframe job3 types are designed for to do the ETL process. difference among them isServer job: execures sequentiall like row by ...
-
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...
-
-
Import Data with More than One Delimiter
DataStage can accept more than one delimiter. How to import data if it contains more than one delimiter?
veer.dwh
- Sep 23rd, 2009
DS supports more than one delimiter, if file has more then one delimiter. to read multiple delimeters from flat file, define flat file type as fixed width.Suppose your flat file has data belowcust_no,...
-
Move data using DataStage
How to move data from operational and external environments to BI environment using datastage software?
Abhijain
- Oct 19th, 2009
Question is not clear.Are you talking about moving OLTP data to OLAP system?
-
SCD2 Parallel Jobs
How to implement SCD2 in parallel jobs?
veer.dwh
- Sep 23rd, 2009
If you are using DS 8.0.1 version, it is very east to implement SCD2 using SCD stage. it supports 2 input links and 2 output links. from the 2 input links. primary Dataset it takes as a current dates...
-
Server Connection
How to connect to the server in datastage?
nikhilanshuman
- Mar 22nd, 2010
Check my answers at the following link:http://www.geekinterview.com/question_details/58767
DataStage Interview Questions
Ans