In datastage 8.1 What is the limit of the file size? Is there limit from # of rows and # of field perspective for file extract to be fed in profile stage

varun khare

 Profile Answers by varun khare Questions by varun khare

• Mar 8th, 2013

In 8.0/8.1 it uses parser which requires the entire XML document to be loaded into memory, so that youre limited by the amount of available memory. In 8.5 it uses a really clever streaming app

Answer Question  Select Best Answer

How to see the data in the Dataset in UNIX. What command we have to use to see the data in Dataset in UNIX?

karn khera

• Feb 23rd, 2013

The command which must be used is orchadmin dump datasetname(without quotes). But before that run this command "cd `cat/.dshome`dsenv" without quotes. The reason is: cd `cat/.dshome`-> This will cha...

Saravanan Mani

• Jun 20th, 2012

Orchadmin rm datasetname

Answer Question  Select Best Answer

Hi all, pls let me know the purpose of using User defined environment variables and parameters sets

MallikarjunaG

• Jan 7th, 2013

An user defined environment variable is a place holder to store a value that can used in the entire project. Parameter set is new time saving feature added in DataStage 8x. Parameter set is set of jo...

Answer Question  Select Best Answer

If are given a list of .txt files and asked to read only the first 3 files using seq file stage. How will you do it?

matan

• Nov 16th, 2012

In sequential file we can take a single file by using the file as Specified file.

But we can take the more than one file use File Pattern with different file names.

Metadata must be same.

narra satish

 Profile Answers by narra satish Questions by narra satish

• Mar 25th, 2011

HI, In sequential file we can take a single file byusing the file as Specifyed file.But we can take the more than one file use File Pattern with different file names.Metadata must be same.

Answer Question  Select Best Answer

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

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