Ashok

• Aug 19th, 2014

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

Answer Question  Select Best Answer

I have explored all the available functions in the transformer stage, but could not find the exact function to get the last day of the current month. Can you please show me which function is available for this logic.

Arunjith B Indivar

 Profile Answers by Arunjith B Indivar Questions by Arunjith B Indivar

• Jul 27th, 2014

DaysInMonth(CurrentDate())

venueksh

 Profile Answers by venueksh Questions by venueksh

• Apr 8th, 2014

Oracle has LAST_DAY function:

SELECT LAST_DAY(to_date(07/04/2014,MM/DD/YYYY)) from dual;
SELECT LAST_DAY(SYSDATE) from dual;

Answer Question  Select Best Answer

Routines are stored in the Routines branch of the DataStage Repository, where you can create, view or edit. The following are different types of routines:   1) Transform functions   2) Before-after job subroutines   3) Job Control routines

Chalapathirao Maddali

• Jul 11th, 2014

Datasatge has 2 types of routines ,Below are the 2 types. 1.Before/After Subroutine. 2.Transformer routines/Functions. Before/After Subroutines : These are built-in routines.which can be called in...

bvrp

 Profile Answers by bvrp Questions by bvrp

• Nov 1st, 2005

RoutinesRoutines are stored in the Routines branch of the DataStage Repository,where you can create, view, or edit them using the Routine dialog box. Thefollowing program components are classified as ...

Answer Question  Select Best Answer

Ramyapriya Sudhakar

• Jul 9th, 2014

operational data store : It is unlike real EDW ,data is refreshed near real time and used for routine business activity. It is used as an interim logical area for data warehouse. This is the pla...

Dharmendra

• Sep 22nd, 2006

An operational data store (or "ODS") is a database designed to integrate data from multiple sources to facilitate operations, analysis and reporting. Because the data originates from multiple sources,...

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

Rajesh B

• Jun 8th, 2014

Hi The hierarchy is nothing but parent and child relationship....
lets say the country is parent -->state is child to it---> city is child to it--->house no is child to it

here if anyone needs hierarchy you can say from country-->state-->city-->house is the hierarchy relationship

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

A Sequences is calling activity 1, activity 2 and activity 3.while running, activity 1 and 2 got finished but 3 got aborted. How can I design a sequence such that the sequence has to run from activity 2 when I restart the sequences?

Mallikarjuna_G

 Profile Answers by Mallikarjuna_G Questions by Mallikarjuna_G

• May 8th, 2014

To make the job re-run from activity 3, we need to introduce restartability in the sequence job. For this below points have to be taken care of in Job Sequence Adding Checkpoints: Checkpoints have t...

Ritwik

• Apr 21st, 2014

You have to check the " Do not checkpoint run " checkbox for activity 2. If you set the checkbox for a job that job will be run if any of the job later in the sequence fails and the sequence is restarted.

Answer Question  Select Best Answer

vij

• Jan 6th, 2014

Default partition technique is Auto in all please check once

mallika_chaithu

 Profile Answers by mallika_chaithu Questions by mallika_chaithu

• Jun 8th, 2011

Hope the below one helps you.Join Stage: 1.) It has n input links(one being primary and remaining being secondary links), one output link and there is no reject link2.) It has 4 join operations: inner...

Answer Question  Select Best Answer

How to remove leading zeros in data and transform data to target?

Sunitha

• Dec 2nd, 2013

The main differences between 8.1 and 8.5 are 8.5 has Input looping ,Output looping. 8.5 has saving ,editing and compling is 40% faster. 8.5 has functions like LastRow,LastInGroup and Iteration system...

Rupesh Agrawal

• Nov 8th, 2013

Convert data to integer and convert back to string.

Answer Question  Select Best Answer

Itishree

• Dec 2nd, 2013

You can use either of the below options: Seq File->Sort->Remove Duplicate ->O/P in Remove duplicate stage, choose the key column and duplicate to retain last properties Seq File->Remove Duplicate ->O/...

Murat Nur

• Dec 28th, 2006

Hi,if ranking means that belowprop_id  rank1         11         21        32&nbs...

Answer Question  Select Best Answer

How can we retrieve the particular rows in dataset by using orchadmin command?

sunitha

• Nov 29th, 2013

Orchadmin dump -part 0 -n 17 -field name input.ds

Sushils13

 Profile Answers by Sushils13 Questions by Sushils13

• Aug 20th, 2013

$orchadmin dump [options] Sample.ds

options : -p period(N) : Lists every Nth record from each partition starting from first record.

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

rajesh

• Oct 26th, 2013

Implement looping concepts in transformer

Seshadri B S

• Jun 19th, 2013

Last row Handling functions in transformer are additional features

Answer Question  Select Best Answer

vinay

• Oct 24th, 2013

Name cleaning
Address cleaning

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

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

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

We use a) "Iconv" function - Internal Convertion. b) "Oconv" function - External Convertion. Function to convert mm/dd/yyyy format to yyyy-dd-mm is Oconv(Iconv(Filedname,"D/MDY[2,2,4]"),"D-MDY[2,2,4]") 

vipul choudhary

• Aug 22nd, 2013

There are two types of hash file

1. modulus hash file- file size increases randomly
2. splitting hash file-file size decreases randomly

Muralidhar

• Jul 29th, 2013

By default datastage date format is :yyyy-mm-dd.The input is mm/dd/yyyy. String_to_date(inputdate,"%mm%dd%yyyy")

Answer Question  Select Best Answer