How to calculate Sum, Averages, Minimum, Maximum salaries of an employee without using Aggregator stage in datastage?

captainvenu

 Profile Answers by captainvenu Questions by captainvenu

• Sep 11th, 2010

Ofcourse by using Tranformation Stage we can do this

Answer Question  Select Best Answer

When we are extracting the flatfiles, What are the basic required validations?

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Dec 9th, 2010

Folllowing are some common validations performed:a) Check for blank lines and remove them.b) Check the number of column in each row of the file.c) If there is a? trailer line in the flat file contain...

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

What is the difference between datastage 7.1 & 8.0.1 versions ?

shyam.kandi99

 Profile Answers by shyam.kandi99 Questions by shyam.kandi99

• Nov 9th, 2010

Diff B/W Data Stage version 7.5 and Version 8.0I ) in 7.5 >> 4 client components in 8.0 5Client ComponentsDS Designer Web ConsoleDS Director Information AnalyzerDS Manager DS DesignerDS Administ...

Answer Question  Select Best Answer

How can we pass parameters from one job to another job by using command line prompt?plz send ans... thanks in advance.Alam

cevvavijay

 Profile Answers by cevvavijay Questions by cevvavijay

• Feb 10th, 2011

We can pass parameter to a job using two ways .. using dsjob- command line or from a sequencer.Other way would be -You configure single parameter set ( version 8.0 onwards) and use the same in both th...

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

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

tapan8984

 Profile Answers by tapan8984 Questions by tapan8984

• Aug 12th, 2011

We can use the Number of readers per Node property to enhance parallelism in Sequential file, hence enhancing the performance..

Answer Question  Select Best Answer

j.padma89

 Profile Answers by j.padma89 Questions by j.padma89

• Jul 14th, 2011

To run 10 or any number of jobs one after the other or in any sequence, One can use "job sequences".

In each sequence one can assign a job, so after the 10 sequences , you can run a sequence job.

Using sequential jobs developer can even decide what should a job do if it is aborted.

amulas

 Profile Answers by amulas Questions by amulas

• Jul 13th, 2011

By using multiple job compile from ds director, we can run multiple jobs at a time.....

Answer Question  Select Best Answer

vinay

• Oct 24th, 2013

Name cleaning
Address cleaning

Answer Question  Select Best Answer

SinhaS

 Profile Answers by SinhaS Questions by SinhaS

• Aug 4th, 2011

1) First check that the Driver has been installed and the library env variable has been set correctly to point to it by the UNIX admin who installed it ($LD_LIBRARY_PATH). 2) Go to $DSHOME and update ...

Answer Question  Select Best Answer

How many number of ways that you can implement SCD2 ? Explain them

RAJESH

• Aug 1st, 2011

3 ways to construct the scd2 in datastage 8.0.1
1)using SCD stage in processing stage
2)using change capture and change applay stages
3)using source file,lookup,transformers,filters,surrogate key generator or stored procedures,target tables

Answer Question  Select Best Answer

What is base partitioning in DataStage how we can implement

Ch S Rajesh

• Aug 1st, 2011

There is no such a question like base partitioning.Based on the requirement the partitioning method of the stage changes.Mostly we will follow auto i.e., datastage will take RoundRobin by default(auto).Partitioning method same will improve the performance characteristics of datastage job.

Answer Question  Select Best Answer

Hi Guys,

I have 3 yrs for experiences in datastage , though not much practical experience due to various reasons, now I have been asked this question in 4 of my interviews and I am always flounder at it . Have tried different approaches , telling the truth , telling a real situation I faced which actually was not that difficult , but I always seems to flounder at this question...

Kamalakar Kalidindi

• Aug 27th, 2013

I too fed up with this question..i gave answer like this, every new job is difficult..when we are building that job for first time, it will be difficult only..among those implementing SCD type -2 (ins...

Answer Question  Select Best Answer

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

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

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

What is the purpose of using user defined environment variables and parameter sets. I m little bit confused. Could any one explain me in detail.?

Charmi

• Jul 1st, 2014

Hi,

Parameter Set is used when you want a set of user defined variables to be used many times in a project.

For example, Variables like Server Name, User Id, Password can be added in a parameter set and that can be used across the jobs , instead of including the three variables everytime.

Answer Question  Select Best Answer

ysubba

• Mar 21st, 2013

Nothing but server name

Answer Question  Select Best Answer

Rupesh Agrawal

• Nov 8th, 2013

No, It is not possible. Both component uses different code base.

Answer Question  Select Best Answer