How we read comma delimiter file in sequential file stage and how we can remove the header and footer from a comma delimiter file?

deepakatsit

 Profile Answers by deepakatsit Questions by deepakatsit

• Oct 29th, 2014

For Removing Header file you can use SED Command of UNIX to remove Header.

deepakatsit

 Profile Answers by deepakatsit Questions by deepakatsit

• Oct 23rd, 2014

For Sequential file there is an option "First Row Column Name" set to true so Header is removed and File End Type You need to select through which Footer is Removed.
Now For Comma Delimiter Use : :"Field Defaults -> Delimiter = Comma"

Answer Question  Select Best Answer

i have a sequence of job in DataStage which is taking more than 4 hrs which is supposed to complete in less than 1 hr
so what could be the possibilities to take much longer time than expected?

RamyaSujith

• Oct 6th, 2014

Check if any stage is reading/processing data sequentially which could have been done in parallel.

Raveena Mittal

• Sep 11th, 2014

When sometimes ,some DML statements are executed in the db and they are not committed,then also it may keep the job running for long hours

Answer Question  Select Best Answer

pundlik

• Sep 5th, 2014

Compared to Informatica the Data Stage is more User friendly

sunrays_arun

 Profile Answers by sunrays_arun Questions by sunrays_arun

• Oct 26th, 2007

SAS DI studio is best when compared to Informatica and Datastage as it generates SAS code at the back end .SAS is highly flexible compared to other BI solution.

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

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