If you have Numerical+Characters data in the source, how will you load only Character data to the target? Which functions will you use in Transformer stage?

raj

• Nov 8th, 2012

Example : raje123ndh456ar

Code
convert(0123456789,,raje123ndh456ar) = rajendhar 

now it is converted to character string and we can load only character.

Vinay Sharma

• Oct 4th, 2012

Use alpha function.
Exp-->alpha(123vinay567)
Ans-->vinay

i thing this is your requeriment..

Answer Question  Select Best Answer

What is the order of execution in the transformer?

amarnath

• Oct 15th, 2012

What is

1.Stage variables
2.Constraints
3.Derivations

AMIT

• Jun 21st, 2012

Order of execution
1. Stage variable
2. Constraints
3. Derivations

Answer Question  Select Best Answer

Source has sequential file stage in 10 records and move to transformer stage it has one output link 2 records and reject link has 5 records ? But i want remaining 3 records how to capture

Shirisha

• Oct 10th, 2012

You can choose O.W option in constraints, so remaining records you will get.

anil_k_nayaka

 Profile Answers by anil_k_nayaka Questions by anil_k_nayaka

• Jan 25th, 2012

In the transformer Stage Constraints we can define the constraints where this records can get to which link so that the missing records can get catched.

Answer Question  Select Best Answer

Scenario- if suppose we have 3 jobs in sequencer, while running if job1 is failed then we have to run job2 and job 3 ,how we can run? plz ans this thanks in advance

Rekha Ramakrishnan

 Profile Answers by Rekha Ramakrishnan Questions by Rekha Ramakrishnan

• Aug 23rd, 2012

In the first sequence trigger condition there would be option like condition, unconditional, failed etc. You can select Unconditional so that even if first sequence fails or succeed it automatically redirect to next sequence.

Gopi N

• Jul 11th, 2012

If the scenario we have like 1st is abort and then trigger 2nd and 3rd do the below, give the trigger condition like, 1> If job aborted give the link trigger condition which is going to 2nd and 3rd j...

Answer Question  Select Best Answer

If you have a huge volume of data to be referenced, which stage will you use? Join or Lookup stage? Why

Gopi N

• Jul 11th, 2012

If we have a Huge data at reference defiantly we should go to Join stage because Look up takes much time to process hence we will use entire partition but in Join stage we will give the sorted data and it will simplify better than Look-up

arjunreddy

• Aug 24th, 2011

Look up stage

Answer Question  Select Best Answer

Gopi N

• Jul 11th, 2012

We can filter the data in hash file based on the key column, If we have a key duplicate we reject in to files as well by writing a SQL statement

Answer Question  Select Best Answer

joel

• Jun 20th, 2012

The above answer is wrong. Please follow the steps below to load the excel in dataastage :- first open excel sheet and open->saveas-> then save the file as .csv extension while importing u have to s...

srinu5077

 Profile Answers by srinu5077 Questions by srinu5077

• Jan 4th, 2012

I did same as step1, but when i import the metadata it asking username and password, when press ok button it shows NO MATCHES FOUND, pls help me

Thank you
Regards
Srinivas

Answer Question  Select Best Answer

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