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

Why lookup is heavy weight and join is light weight operator?

sireesh vasantha

• Aug 3rd, 2015

LOOKUP use RAM to perform operations where as JOIN use buffer to perform operations

Answer Question  Select Best Answer

Is it possible to find out the maximum salary by using remove duplicate stage? Can you any one explain?

Thanks in advance

deepakatsit

 Profile Answers by deepakatsit Questions by deepakatsit

• Sep 10th, 2015

Hello Balu,
You can achieve Maximum salary by using remove duplicate.

Input File --> sortstage( Ascending or descending) --> Removeduplicate ( In remove duplicate Retain last if sorting ascending or retain first if sorting in Descending order ) --> output file.

Hope this will help.

Answer Question  Select Best Answer

I have two columns of data
My input data
Field Name Value
Customer_ID 100
Customer_Name ABC
Customer_City Kolkata
Customer_ID 200
Customer_Name BCD
CUstomer_City Mumbai

Customer_ID 300
Customer_Name CDE
Customer_City Delhi

Output date should be
Customer_ID Customer_Name Customer_City
100 ...

Pavan Kumar

• Sep 18th, 2015

You can use pivot enterprise stage to achieve the desired output.
Source >> Pivot Enterprise >> Destination. In Pivot set array size as three to spit the data into three records. Note that you are doing vertical pivot here not horizontal.

Answer Question  Select Best Answer

How to extract last 3 days data using SCD?

venkat

• Mar 28th, 2016

Use SCD Type 2 then get the last 3 days data.

Answer Question  Select Best Answer

I would like to know if you could help me out. I have a a file with 2 columns (TABLENAME and CLOB) and in the TABLENAME there are "Providers". I would like to know how to set them at number 5000 and then increment them, per provider. So if I have 5 providers per file, it would be 5000, 5001, 5002, 5003, 5004. This is a daily file so we will get a file everyday. So Day 2, the 1st provider must be 5005...

nikhil

• Dec 11th, 2015

From your question it appears that you want to generate a surrogate key with 5000 as seed value. This can be done through surrogate key generator using state file property and increment by 1. Set generate from last highest value also

Answer Question  Select Best Answer

I have heard of both Convert and Ereplace but I am stumped. I need to take every double dash (--) from my files and convert them to a single hyphen (-). What would be the best way to do this?

nikhil

• Dec 11th, 2015

Based on your need ereplace or change function will be better choice. Convert will treat (--) as 2 different characters.

Answer Question  Select Best Answer

Identify Header, Detail and Trailer records in the incoming file and verifying whether trailer count is equal to total number of detail records.

My input is
Header Columnname
Detail row 1
Detail row 2
Detail row 3
Trailer 3

Here I want to see whether total number of detail records is equal to total number of trailer record.
If so proceed...

Ram

• Jun 30th, 2016

You need to do file validation part using shell or any other scripting as before subroutines.

Answer Question  Select Best Answer

Basically which data model do we use in the project?

Pavan Kumar

• Jul 5th, 2016

Hi alok It totally depends on the project. 1) Entity Relation model or ER model is used when the data source is small as the number of joins are less. 2) Dimention model a) Star : Used for...

Answer Question  Select Best Answer