Shiv

• Jun 15th, 2012

1. Dynamic RDBMS is the only stage that supports N inputs and N outputs.
2. Using Dynamic RDBMS we can read multiple tables independently.

Answer Question  Select Best Answer

mcrao1

 Profile Answers by mcrao1 Questions by mcrao1

• Jun 4th, 2012

DataStage Job run from Unix Command Line I am running DataStage Job from Unix Command Line with job level parameters the job is getting abort , can someone correct if there is any syntax problem in t...

Pavan

• Aug 29th, 2005

We can call Datastage Batch Job from Command prompt using 'dsjob'. We can also pass all the parameters from command prompt. Then call this shell script in any of the market available schedulers. The 2nd option is schedule these jobs using Data Stage director.

Answer Question  Select Best Answer

Jobin Joseph Veliyath

• May 30th, 2012

The errors can be handled in different way, will list few of the methods which we can achieve via ETL If it is a critical fact table (Merchandise, location and time (weekly)) then Non-Critical Data...

Answer Question  Select Best Answer

What are the different types of constraints ?
Difference b/w unique and not null constraints?

SURESH

• May 6th, 2012

Constraints are used for filter the data as transformer stage and from in sql different type of constrains having null, isnull, primarykey,foreign key and unique constrains Ans unique constrain is not allowed duplicate values and Notnull constrain means should be having a data in that column.

suresh

• May 4th, 2012

Constrain is nothing but it is an condition, it is might be any type of condition. and second one is unique and not null means unique is maintain one record do not accept duplicate record . not null m...

Answer Question  Select Best Answer

praveen

• Apr 28th, 2012

Data set and file set are file/stage ,these to are data extract from db.in the data set does not have rejected link file set had rejected link

arjun

• Jan 25th, 2012

The fundamental concept of the Orchestrate framework is the Data Set. Data Sets are the inputs and outputs of Orchestrate operators. As a concept a Data Set is like a database table, in so far as it...

Answer Question  Select Best Answer

pradeep

• Apr 20th, 2012

Actually Data stage director is the GUI based component and this is the Clint component, The main use of Director is view logs, we can see view log and status of running job,By using the multiple instances we can run the job in period of time for testing propose.schedule the job.

abhijeet

• Mar 12th, 2012

DS Administrator is use to see the log of job.Administrator monitor the job.

Answer Question  Select Best Answer

pradeep

• Apr 20th, 2012

To the best of my knowledge, By using partitioning technique may be used for performance increases. and to select relevant stage for developing transformation

Answer Question  Select Best Answer

DS 7.0.2/6.0/5.2

svr

• Mar 7th, 2012

7.5 is single execute system 8.01 is multiple execute system

file based repository
database repository

it is used in change capture & change apply stages. Here we r using SCDS like 1,2,3

glaciya

 Profile Answers by glaciya Questions by glaciya

• Dec 13th, 2011

Datastage 7.5x2

Answer Question  Select Best Answer

Seio

• Feb 25th, 2012

I'm interested in this answer because for any reason my jobs appear not compile after I begin the execution and I need an automatic process that auto compile the jobs when it founds uncompiled.

Thanks.

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Mar 19th, 2010

If the job failed to compile, there must be some problem with the job.If the problem is not fixed then no matter how many times it is recompiled, the compilation will fail each time.Automatic recompile?option does not seem to be there in datastage.

Answer Question  Select Best Answer

KRISHNA

• Feb 19th, 2012

How to explain insurance project in datastage?

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Dec 17th, 2010

Explain the interviewer about your project, its architecture and your role in that project. The role can be developer, Tester, BA, lead etc.. Also, explain what you did in that project like coding, preparing UTC, contributing effectively with testers to complete the UAT phase of the project etc...

Answer Question  Select Best Answer

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

 Profile Answers by Gokul21 Questions by 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.

Answer Question  Select Best Answer

How to get the reject records from join stage?

AvelinCorreia

 Profile Answers by AvelinCorreia Questions by 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

Answer Question  Select Best Answer

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

 Profile Answers by MArcus_Datastage Questions by 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...

Answer Question  Select Best Answer

What happens if we run 7.5 vesion job in 8 version? what is the error?

Mohammadsadiq

• Feb 2nd, 2012

If we compile Datastage 7.5x2 job in compatible mode then it will run....if you wont complied and run in 8.x....then it will pop up some error

Answer Question  Select Best Answer

Where do you specify nodes for datastage jobs?

srinivas

• Jan 30th, 2012

Node is nothing but an identified by the number of nodes on which parallel jobs can run r not

j.padma89

 Profile Answers by j.padma89 Questions by j.padma89

• Jul 18th, 2011

In app config file which will be named as default.apt

Answer Question  Select Best Answer

vjviji86

 Profile Answers by vjviji86 Questions by vjviji86

• Jan 30th, 2012

I work on Datastage 8.1 ...Most of the Clients framework prefers Connect DirectProtocol when compared to SFTP?

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by 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...

Answer Question  Select Best Answer

anil_k_nayaka

 Profile Answers by anil_k_nayaka Questions by 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

Answer Question  Select Best Answer

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

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Dec 25th, 2009

A switch stage can have maximum 128 output links.A filter stage can have any number of output links.

Answer Question  Select Best Answer

How to extract your flat files using sequntial file or dataset? From where to get these flat files as source?

manish parashar

• Jan 10th, 2012

Flat files can be accessed from unix by using sequential file stage. For example if we are having csv file . we can give the path in the sequential stage for this file and we can access the file directly.

Answer Question  Select Best Answer

I can only see the name of the stage variables but cannot see the definition, where can I find them?

manish_toy

 Profile Answers by manish_toy Questions by 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

 Profile Answers by manish_toy Questions by 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.

Answer Question  Select Best Answer