-
XML File
How to read an XML File?
vujjini1974
- Sep 29th, 2009
Use a XML Folder stage to read the XML file and pass the content to XML Input stage to parse out tabular records.
-
Datastage ETL
What is Datastage ETL?
nikhilanshuman
- Dec 25th, 2009
ETL stands for Extract,transforam and Load.Datastage is an ETL tool which extracts the data from source,applies the necessary transformations on the data and loads the data into target.
-
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
-
Configuration File
What is configuration file? What does it contain? What is the use of it in Datastage?
nikhilanshuman
- Dec 25th, 2009
A configuration file contains the information about the nodes,Resource disk and the Resource scratch disk.The datastage parallel jobs run on the basis of the configuration specified in the configurati...
-
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
-
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...
-
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."
-
Convert Column into Rows
How to convert columns into rows without using Pivot node?
captainvenu
- Sep 11th, 2010
Pivot is not a node ok. and as per my knowledge without pivot we unable to convert columns in to rows
-
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.
-
Data Stage Language
What is the Language of Data Stage?
-
Split Data From Flat File
How do you split the data from a flat file in to columns?
-
Data Vaidations
What various validations do you perform on the data after extraction?
-
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.
DataStage Interview Questions
Ans