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

Sushils13

 Profile Answers by Sushils13 Questions by Sushils13

• Aug 22nd, 2013

The Datastage configuration file is specified at runtime by a $APT_CONFIG_FILE variable. Configuration file structure Datastage EE configuration file defines number of nodes, assigns resources to ea...

Answer Question  Select Best Answer

I have source like this

Num, SeqNo,Ln,Qty
101, 1 ,1,5

I wanna target following below

Num,SeqNo,Ln,Qty
101, 1 , 1, 1
101, 1 , 2, 1
101, 1 , 3, 1
101, 1 , 4, 1
101, 1 , 5, 1

Based on Qty value records will be incremented.If qty value is 4 then o/p will be like below

Num,SeqNo,Ln,Qty
101, 1...

akhilesh.shivhare

 Profile Answers by akhilesh.shivhare Questions by akhilesh.shivhare

• Sep 13th, 2013

Yours i/p data

Num,SeqNum,Ln,Qty
101,1,1,5


and o/p data

Num,SeqNum,Ln,Qty
101,1,1,1
101,1,2,1
101,1,3,1
101,1,4,1
101,1,5,1

steps-

- use transformer
-define stage variable stgvar_Qty with value 1 means stgvar_Qty=1
-define loop with condition @ITERATION

Answer Question  Select Best Answer

How to find if the next value in a column is incrementing or not

for ex
100
200
300
400

If the curval greater than previous val then print greater if lesser print lesser

For ex
100
200
150
400, Here 150

karthick

• May 30th, 2014

Previous value in one stag_v1 and presend value in stg_v2 compare the two , if greater then stg_v1=stg_v2 and move to next value. else loop it.

Answer Question  Select Best Answer

How to get a files from different servers to one server in datastage by using unix command?

Murali

• Aug 19th, 2014

Code
scp test.ksh dsadm@10.87.130.111:/home/dsadm/sys/

Answer Question  Select Best Answer

Ashok

• Aug 19th, 2014

You can display files date wise by doing normal ls -latr cmd

Answer Question  Select Best Answer

How can we identify updated records in datastage? Only updated records without having any row-id and date column available.

Vikram Singh

• Nov 11th, 2014

I believe you can use the change capture stage which will show you the data before any update change made and after the update change was made. Should work, if there are no other constraints.

Answer Question  Select Best Answer

I have table(Emp) with the columns Eid,Ename,Sal,month(sal),year(sal) and DOB (say 15th-Jan-1981).
Design a job such that the output displays Ename,year(sal),tot(sal) and current age i.e. For Ex: 18 yrs

barak

• Nov 21st, 2014

Using Transformer Days Between and divided by 365 - we can check for year with 366 if that's a big deal .

Answer Question  Select Best Answer

What are the Datastage native operators??
C
C++
BASIC
OSH

Could you brief this please

srinivas

• Nov 26th, 2014

OSH (orchestrate ) is the answer , when we develop any parallel job it converts into OSH script in the back ground , of course C++ because when we use transformer stage the code generated in the background is C++.

Answer Question  Select Best Answer

Having single input in the source wants the repetition of the input in the column of the target using only copy stage.

@sheesh

• Dec 4th, 2014

Use entire partition and run on multiple nodes

Answer Question  Select Best Answer

I have
source
10
20
20
reference 10
20
20

can someone tell me how a cartesian join performed using a join stage in datastage.

Thanks
Sravanthi

satjay

• Mar 17th, 2015

Create a dummy key column in both the links (eg with value 1) and join with this key column. This is the approach to join two tables without keys.

Answer Question  Select Best Answer

Murali

• Jun 2nd, 2015

SCD type 2 can be implemented by adding Surrogate Key. The existing Primary Key will be considered as a Natural Primary Key and the Surrogate Key will be your Primary Key.Also, Start date & End date (...

Answer Question  Select Best Answer

Can anybody solve this interview question in DataStage?
My input is:
EMPNO, DEPTNO, SALARY
1 A 100
2 A 4000
3 A 400
4 B 500
5 B 150
6 B 700

I need extra column "Rank" in the output is:

EMPNO, DEPTNO, SALARY,...

surya

• Sep 16th, 2015

1. Source-->sort(dept,sal), partition (hash(dept))
2. Transformer(rank=inrownum (inrownum will be rownumber in a partition which is nothing but rank)

Answer Question  Select Best Answer