sankarganeshvel

 Profile Answers by sankarganeshvel Questions by sankarganeshvel

• May 13th, 2008

Hi ,if your job is using OCI stage as the target stage  .then u can do it. just specify the no of the record in the Transaction handling of the OCI stage . So if the job get aborted after 1000 records  ,say some 1220 then 1000 record will be there in the target table 

nagoosk

 Profile Answers by nagoosk Questions by nagoosk

• Apr 22nd, 2008

It is possible to restart the job after the aborted rows.You have to select the "check point" property in the sequence.There you have to give the aborted final record number.This is only in datastage(PX)

Answer Question  Select Best Answer

RAM

• Aug 27th, 2015

SMP is a shared Disk. Its having 62 or 124 CPUs.
MPP is a shared nothing or clustered systems . We can say combination of multiple SMPs.

Himanshu Maheshwari

• Apr 2nd, 2015

The environment in which you run your parallel jobs is defined by your systems architecture and hardware resources. All parallel processing environments are categorized as one of: SMP (...

Answer Question  Select Best Answer

jaffar95

 Profile Answers by jaffar95 Questions by jaffar95

• Mar 20th, 2008

Yes you can query a hash file using Datastage Administrator --> Command  window -->

John

• Feb 8th, 2007

You can also use a Universe stage if the data is need in your job. I don't recall all details when I used this but I think there is an option when creating the hash file to make it Universe compatable or something like that. Then you can use it in a universe stage and do any query you like on it.

Answer Question  Select Best Answer

How to remove duplicates in datastage?

dwh_com

 Profile Answers by dwh_com Questions by dwh_com

• Jun 22nd, 2008

There are several ways in removing the duplicates depends on the data u have..have to use stage variables effectively to remove the duplicates.use rowprevious compare function.. which is available in datastage...RegardsSriks

Suri123

 Profile Answers by Suri123 Questions by Suri123

• May 9th, 2008

In parallel jobs by using sort stage Or Remove Duplicates stage We can remove duplicate records Regards Suri

Answer Question  Select Best Answer

Anil.K.Thodeti

• Mar 31st, 2017

Cat abc.txt | tr
, | sed s/,$//(Exec command stage), Start Loop (pass this output $CommandOutput), and then send this into a job, and then end loop at the end

karthick

• May 30th, 2014

Parameter file will have comma delimiter.
use cat file1.txt |cut -d, -f1| tr -d "
" command to extract the first field ...
use execute command activity for extracting all the parameter. then finally pass the value to actual job.

Answer Question  Select Best Answer

SRC has 1 record I want 10records in target how is it possible ? plz explain me ?

Ram

• Mar 31st, 2016

Src --> Transform --> Trg

Use Iteration < = 10 for the records...
So you will 10 records in target.

Nikhil

• Dec 15th, 2015

Take a rowgen stage, limit number of rows=9, funnel it src file

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

hi

i have sourse like
name,city
johny,newyork
johny,mumbai
johny,del

want output like
name,city1,city2,city3
johny,nework,mumbai,delhi

thanks in advance..

Sharali Sharna

• Nov 24th, 2015

You can use Pivot Enterprise stage to achive this.

Abhinandan

• Nov 20th, 2015

Use 2 stage variable in transformer
Stagevar: if Stagevar1=sno then marks:",":Stagevar Else marks
Stagevar1: sno

map stageVar to marks

Answer Question  Select Best Answer

I have two files target 3 files

file no1:
1
2
3
4

file2
3
4
5
6

output like first file 1,2 first file 3,4 second file 5 ,6 3rd file target how to achieve this

Thwara

• Jul 15th, 2017

First copy the value from your seq. file using "copy stage", then use "funnel stage" to join the two seq. file, then sort them and use "remove duplicate stage" to find the duplicate values (eg: 3,4) t...

Amit

• Jul 28th, 2015

Basically Question is about how you will achive Left Join, Inner Join and Outer Join.

Answer Question  Select Best Answer

I have column X which having 3 values A;B;C. How can I load these values into 3 diff cols in the target. If tomorrow I will receive 100 values for same single column I will load into 100 target cols respectively (Same de-limiter) ?

Roopa

• Mar 2nd, 2018

Using Field function. Field(column,delimeter,1) and so on

ABACHREK

• Mar 3rd, 2017

Loop through the incoming field using looping functionality in transformer. Extract the individual values using field function and the iteration number. Output the individual values to the output link...

Answer Question  Select Best Answer

pradeep

• Apr 20th, 2012

Actually Data stage director is the GUI based component and this is the Clint component, The main use of Director is view logs, we can see view log and status of running job,By using the multiple instances we can run the job in period of time for testing propose.schedule the job.

abhijeet

• Mar 12th, 2012

DS Administrator is use to see the log of job.Administrator monitor the job.

Answer Question  Select Best Answer

rohitdagar

 Profile Answers by rohitdagar Questions by rohitdagar

• Jan 17th, 2009

Start DataStage Engine Resource Service, DataStage Telnet Service and DSRPC Service in control panel
- Administrative tools - Services or directly run command "services.msc"to open services window..

Hisin

 Profile Answers by Hisin Questions by Hisin

• Jun 26th, 2008

You must give an IP adress by configuring in panel config => Network

Answer Question  Select Best Answer

manoharkolukula

 Profile Answers by manoharkolukula Questions by manoharkolukula

• Jan 25th, 2008

Here in server we have to use some stages like link partitioner, link coll, inter process.. to implement ll'lism. And sometimes we have to use lot of stages to implement specific logic bcoz of&nbs...

sanchit_states

 Profile Answers by sanchit_states Questions by sanchit_states

• Jan 18th, 2008

Server jobs while using look up converts code into .osh languagewhile Parallel converts the code in C++ code ..leading to the req of VC++ compiler.

Answer Question  Select Best Answer

What is the uses of the copy stage with out copies input link to output link datasetsand it can have any purposes pls send me with example

Mallikarjuna_G

 Profile Answers by Mallikarjuna_G Questions by Mallikarjuna_G

• Aug 10th, 2013

Use Copy stage for simple operations like :

to multicast the same input data among multiple output links.
placeholder between stages to avoid buffer issues
renaming Columns
dropping Columns
implicit (default) type Conversions

Akila

• Apr 1st, 2013

Besides used for making copies of the input, copy stage is also helpful for achieving 1) dropping columns between stages 2) to change column names 3) if the scenario is to end the job flow directly f...

Answer Question  Select Best Answer

In almost all cases we have to delete the data inserted by this from DB manually and fix the job and then run the job again.

Read Best Answer

Editorial / Best Answer

ritu singhai  

 Profile Answers by ritu singhai Questions by ritu singhai

• Member Since Jul-2008 | Jul 5th, 2008

---

Have you set the compilation options for the sequence so that in case job aborts, you need not to run it from from the first job. By selecting that compilation option you can run that aborted sequence from the point the sequence was aborted.
Like for example, you have 10 jobs(job1, job2, job3 etc.) in a sequence and the job 5 aborts, then by checking "Add checkpoints so sequence is restartable on failure" and "Automatically handle activities that fail" you can restart this sequence from job 5 only. it will not run the jobs 1,2,3 and 4.
Please check these options in your sequence.
Hope this helps.

Mallikarjuna_G

 Profile Answers by Mallikarjuna_G Questions by Mallikarjuna_G

• Aug 10th, 2013

Two things needs to be handled when a Job Sequence aborts. 1. We must have an exception handling code that notifies us about the failure 2. When we re-run the sequence after fixing the Sequence, it ...

Riten

• May 30th, 2012

To Handle Aborted Sequence These are the steps to be taken: First Add Terminator to Job Sequence and Choose Terminator with Other option(Trigger in Job sequence) ( if job fails it will go to Other lin...

Improve Answer

praveen

• Apr 28th, 2012

Data set and file set are file/stage ,these to are data extract from db.in the data set does not have rejected link file set had rejected link

arjun

• Jan 25th, 2012

The fundamental concept of the Orchestrate framework is the Data Set. Data Sets are the inputs and outputs of Orchestrate operators. As a concept a Data Set is like a database table, in so far as it...

Answer Question  Select Best Answer

veer.dwh

 Profile Answers by veer.dwh Questions by veer.dwh

• Sep 28th, 2009

There are several performance techniques are avilable to help run the job faster1. Eliminate unwanted data and columns as early as possible in your job design, each unwanred column and data  requ...

Bhaskar

• Dec 29th, 2006

We can put hash file in lookup. This will index the input data based on key column (which we define). Thus improve performance. Also Array size can be increased in final table stage.

Answer Question  Select Best Answer

Anjaneyulu Pagadala

• Mar 15th, 2018

Hash partitioning and in link sorting on grouping keys give better performance and correct results if it is in parallel mode and Auto partition will give correct results if there is no sorting happened only one of the keys we are grouping in previous stage

yassine

• Jul 12th, 2017

Hello Harish I would like to ask you a question How I can choose the appropriate partition for each stage and job how can I analyse situation
thank you

Answer Question  Select Best Answer

How do you you delete header and footer on the source sequential file and how do you create header and footer on target sequential file using datastage?

Monisha jain

• Jul 31st, 2017

In sequential file using filter property where we can use UNIX command: sed -e 1d -e 1p

sri

• Mar 28th, 2017

Use UNIX command in the sequential file stage
sed -n1!p filename|sed -n $!p

Answer Question  Select Best Answer

How to Delete Dataset in Datastage Parallel Jobs?

ramoojobs

 Profile Answers by ramoojobs Questions by ramoojobs

• May 11th, 2010

From Unix / Linux1) Go to the path where DataSet exists2) Use ORCHADMIN DELETE

siddy76

 Profile Answers by siddy76 Questions by siddy76

• Dec 8th, 2009

Go to the particular folder where the datasets are located, then typeorchadmin rm <datasetname.ds>

Answer Question  Select Best Answer