-
Commit and Rollback
How do you perform commit and rollback in loading jobs? What happens if the job fails in between and What will you do?
Sivaramakrishna
- Feb 23rd, 2012
There is an option in RDBMS stage as Transaction Isolation tab whether data commit or un commit.
Gokul21
- Jul 12th, 2010
There is an option called "Transsaction Grouping" is available. You can specify the condition there to commit or rollback if the job fails. This option is available in teradata.
-
Join Stage Reject Records
How to get the reject records from join stage?
AvelinCorreia
- Feb 23rd, 2012
If you want rejected records also, you need to use an outer join so that all the records are carried forward and then youll need to use next stage as a transformer. In the transformer, you can use appropriate condition in the constraints and redirect the unwanted records to a sequential file.
Bharath
- Feb 14th, 2012
Outside the join stage, you can put a filter to filter out the records having null values for the columns coming from right part of the join
-
User Created Stages
Explain Wrapped, Build and Custom stages?
Phuzzball
- Feb 15th, 2012
Datastage allows you to create your own stages with custom properties. There are three types of custom stages: Custom: This is Orchestrate based custom stage. Orchestrate operators are used for def...
MArcus_Datastage
- Mar 17th, 2009
Custom: This allows knowledgeable Orchestrate users to specifyan Orchestrate operator as a DataStage stage. This is then availableto use in DataStage Parallel jobs.Build: This allows you to design and...
-
Transformer stage Compilation Error in Ascential Datastage 7.5, Windows XP
Hi,
I have installed the datastage 7.5 in XP operating system, also installed visual studio .net 2008 for c++ compiler. But when trying to compile the datastage job which contain the transformer stage, I am unable to compile.
Below warning I am getting:
Warning: the PWD
environment variable is not defined. Remote process start up may be
unsuccessful as... -
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 connect from client machine to Unix server in Datastage?
vjviji86
- Jan 30th, 2012
I work on Datastage 8.1 ...Most of the Clients framework prefers Connect DirectProtocol when compared to SFTP?
nikhilanshuman
- Mar 17th, 2010
In Datastage there are the client components like Designer, Manager, Director.When you open these applications, you are asked the user id, password and the Project name to which to want to connect.The...
-
What is DataStage Multi-byte, Single-byte file conversions in Mainframe jobs? what is UTF 8 ? whats use of UTF 8 ?
anil_k_nayaka
- Jan 25th, 2012
UTF 8 is a type of file format to read files in dos format by datastage jobs.
This file may contain characters not only in English but also in foreign language -
What is the difference between a Filter and a Switch Stage ?
kaps3157
- Jan 24th, 2012
Both stages functionality and responsibilities is same. But the difference way of execution like.. In filter stage, we have to give the multiple conditions, on multiple columns. But every time data ...
nikhilanshuman
- Dec 25th, 2009
A switch stage can have maximum 128 output links.A filter stage can have any number of output links.
-
Flat File as Source
How to extract your flat files using sequntial file or dataset? From where to get these flat files as source?
-
Cannot find stage variables definition in the trasformer stage properties
I can only see the name of the stage variables but cannot see the definition, where can I find them?
manish_toy
- Jan 10th, 2012
If you are not able to view the definition then its has not been given. You have to provide the definition by double clicking to the left of the variable and give the definition as per your requirement.
manish_toy
- Jan 10th, 2012
If it is not visible in the transformer stage then the definition has not been given. You have to provide the definition for the stage variable by double clicking to the left of the variable, then you can give the definition as per your requirement.
-
All the user defined environmental variables and assignee values for it. but Encrypted IE password i am not able to read. if it reads only in the server job it is able to read. not from the sequencer. it says password error...
glaciya
- Dec 16th, 2011
Please check your language, it may be the language of your computer did not match your servers language.
-
Stage Variables Initialization
What are the initial values of stage variables? How can we set this values?
glaciya
- Dec 12th, 2011
In my thought, the inital variables are the variables which can be defined when you just have installed the software, in another word they are usually called default variable or you have the first chance to create and config some variables that are used in a stage.
G. Venu
- Oct 14th, 2011
In Transformer stage properties we can set the stage variable initial value.
-
Unknown transformer variable definition
I can see the names of newly defined variables in the transformer stage property, but I cannot see the definition and the logic under it. Is it normal? Where can I find the definition of the stage variables?
-
How to use change capture stage in scds
Could any one please explain me how can we use change capture stage for scd1,2,3 types?
-
Lookup Stage
What is meant by Lookup Stage?
shri
- Oct 18th, 2011
Lookup stage is similar as join stage,what ever the records from source to target we can use by using lookup, join and in the lookup we have reject link option and join doesn't have reject link option.
j.padma89
- Jul 18th, 2011
Look up stage is used to join dataset which has similar functionality of join stage with some extras.
the difference between join and look up is here
http://www.geekinterview.com/question_details/82179
Hope it helps ! -
How do you remove duplicates in dataset
in how many ways we can delete dataset? If a record is duplicated 3 times then how to get middle duplicated record? Is it advisable to use basic Tfr in Parallel jobs?
chhavis928
- Oct 9th, 2011
We can use filter stage here to get middle record from 3 duplicate records.
srkreddy111
- Aug 12th, 2011
First you have to open the data set and click on the partitioning and after click hash partition and next click perform sort after click on unique and after ok and after compile and run the job.open the target output,the duplicate records are removed..
-
What is job commit in Datastage?
What is job commit in Datastage?
If I am working on parallel jobs, how can I give this option(in each odbc satge) that commit should perform after specific number of records transaction.
Please help -
What is the max size of Data set stage?
Venkat Duvvuri
- Sep 9th, 2011
S I agree with Hari's answer..Thae max size of the dataset stage is entirely depends upon the size of the resource disk space, which we have specified under config file.
Regards,
Venkat Duvvuri
harishsj
- Mar 14th, 2008
The Max size of a Dataset is equal to the summation of the space available in the Resource disk specified in the configuration file.
-
Rate Routing & Standard routing difference
Can anybody tell in detail why we use Rate Routing in Repetitive Mfg. instead Normal Standard Routing?
DataStage Interview Questions
Ans