A sequential file has 8 records with one column, below are the values in the column separated by space,1 1 2 2 3 4 5 6In a parallel job after reading the sequential file 2 more sequential files should be created, one with duplicate records and the other without duplicates.File 1 records separated by space: 1 1 2 2File 2 records separated by space: 3 4 5 6How will you do it

Ram

• Jul 1st, 2016

Hi Pooja, Its absolutely possible.. Src --> Copy(linksort) ---> Aggr(count rows) another link from copy -----------------> Join (Copy & aggr) ---> Filter(count=1 for trg1 and co...

Pooja Trivedi

• Jun 30th, 2016

This will not give the desired output as the we want the duplicate records also n number of times where n is the number of record present in the file.

Answer Question  Select Best Answer

How we will generate Surrogate Key in Database not in Datastage.

Aloka

 Profile Answers by Aloka Questions by Aloka

• Jul 1st, 2016

Thanks Ram !

Ram

• Jun 30th, 2016

Hi Aloka,
we can generate surrogate key on database creating sequence object.
syntax: sql > create sequence < seq_object name >

Answer Question  Select Best Answer

In join stage how we will store the rejected record in one file?

Aloka

 Profile Answers by Aloka Questions by Aloka

• Jul 1st, 2016

Thanks Ram !

Ram

• Jun 30th, 2016

Hi Aloka,
Join stage doesnt support reject link. so just connect join stage --> Transformer stage and provide constraints on Transformer to get rejects in Join stage.

Answer Question  Select Best Answer

I have faced an interview question recently.

In database we are using Bulk Collect concept to load the bunch of records ata time.

How we will achieve the same process in Datastage ?

Can we use any paticular stage or any other methodology we can implement.

Can any one help me on this.

Thanks in advance.
Aloka

Avni

• Jun 10th, 2016

Bulk collect is retrieving multiple rows. With a single fetch.. Datastage is by default working in parellel and processing multiple rows at a time. As per my knowledge there is no such specific way to implement this

Deepak Sharma

• Jun 9th, 2016

I think your question is about bulk load of data. I have used Bulk Load method in Oracle Connector stage. Setting Bulk load property ensures that data gets loaded in the bulk load mode.

Answer Question  Select Best Answer

You are given 2 jobs say job A and Job B with parameters x and y respectively. You need to create a sequence job. If you pass parameter x then Job A should run, If you pass parameter y then Job B should run, if you dont pass any parameter then Both Job A & B should run

Bharath

• Apr 3rd, 2016

create a sequence job. User_var_act ----> Nested_Condition_Activity----> In Nested condition Activity define two parameters with the values for example JOB1 and JOB2. Link the nested condition ac...

Rohit

• Sep 24th, 2015

This can be done by the use of user variable and nested stage.Define a user variable with the arguments as parameters x and y. After his pass this variable to a nested activity stage. Generate 3 outpu...

Answer Question  Select Best Answer

Solve in Datastage

Input:

col1, col2, col3
----------------
a, b, c
d, e, f

Output like

Col
---
a
b
c
d
e
f

Ram

• Mar 23rd, 2016

Src --> colgen(Dummy) --> Pivot (type=Horizntal & derivaion col=col1,col2,col3) -->copy(drop dummy col) --> trg.

sai3689

 Profile Answers by sai3689 Questions by sai3689

• Oct 10th, 2015

In the properties Pivot type=horizontal Tell me which to take pivot column?

Answer Question  Select Best Answer

How to get the dataset record count? with out using orchadmin command

Priyanka Sinha

• Mar 17th, 2016

1) The Datastage Designer GUI (also available Manager and Director) provides a mechanism to view and manage data sets. It can be invoked in Tools -> Data set management. 2) orchadmin command-line uti...

Mallikarjuna_G

 Profile Answers by Mallikarjuna_G Questions by Mallikarjuna_G

• Aug 10th, 2013

There are only two ways to this -

1. Use datastage dataset management utility[GUI].
2. Use orchadmin utility from commandline

Answer Question  Select Best Answer

I have 3 jobs A,B & C, which are dependent each other, I want to run A & C jobs daily and B job run only on Sunday. How can I do it?

sudheer

• Aug 20th, 2015

A Job ----> Routine Activity ---Sunday---> B Job ----> C Job
--- Not Sunday -----> C Job

bimaljsr@gmail.com

• Aug 10th, 2015

Sequence Design -

A Job---> (B sequence explained later) --> C Job

B sequence contents
Dummy job to check specific day ---> condition activity with 2 link --> if Sunday run job B, if not Sunday run dummy job and finish.

Answer Question  Select Best Answer

Hi all,
I have 100 rows in a table and want to distribute the data by 4 equal parts and write to four sequential file. here the source data keeps changing. Example : if source data is having 1000 rows the target files have to get 250 rows each in the four files.
1000/4 = 250 each
100/4 =25 each

jallu

• May 27th, 2015

Read the data from sequential file and pass the through sample stage and put the 4 targets ,in sample stage set the properties percentage mode=25% we can get require output

Nish

• May 26th, 2015

source-> Transformer->Target. 4 targets from Transformer stage. Map the input to all the 4out put stages. now each link will have the following constraints respectively. Link1 :Mod(@INPUTROWNUM,4)=...

Answer Question  Select Best Answer

input is
cola
1
2
3
this should be populated at the output as

cola
1
2 2
3 3 3

satish

• Apr 2nd, 2015

In Transformer use stage variable Str(%Input_column%,%Input_column%)

sai3689

 Profile Answers by sai3689 Questions by sai3689

• Mar 17th, 2015

@iteration

Answer Question  Select Best Answer

Source is a flat file and has 200 records . These have to split across 4 outputs equally . 50 records in each .

The total number of records in the source may vary everyday ,according to the count records are to split equally at 4 outputs.

Could someone post an answer for this question.
Thanks

Vinay

• Mar 20th, 2015

We can use the split command in the Filter section of the Sequential

file stage:
Split -l 50 File.txt Segment
O/P: will give 4 files namely Segmentaa,Segmentab,Segmentac and Segmented each of 50 records.

Gandhi

• Jan 13th, 2015

Hi all,

Keep four files as output.Simply give modulus(col_name,4)=0 constraint for first file ,modulus(col_name,4)=1 second file and modulus(col_name,4)=2 for third file and finally modulus(col_name,4)=3

Answer Question  Select Best Answer

Ishu

• Feb 20th, 2015

Use of parameters: 1. avoid hardcoding. 2. Incase a value for some parameter is changed in future, we can change it at a single point instead of making changes everywhere in every job wherever it is ...

Lubna Khan

• Jan 27th, 2014

By Using Parameters we can avoid hardcoding and assign values at runtime

Answer Question  Select Best Answer

I have two columns in the source , COl A and Col B .
Input is like
Cola Colb
100 ABCDEF
I should achieve the output as
Cola Colb
100 A
100 B
100 C
100 D
100 E
100 F

Note : Colb is not of fixed length .

Yash

• Jan 7th, 2015

Its pretty much easy using loop.

With below loop conditions in transformer.You can easily achieve it

Loop Condition: @ITERATION

praveen

• Nov 25th, 2014

Use pivot stage

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 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

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

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

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

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