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

Which partition followed by joiner,merge. lookup,remove duplicate

lalit

• Oct 9th, 2017

For join, merge and remove duplicated you can use Hash partitioning and for lookup you can use entire partitioning
Thank you

Mallikarjuna_G

 Profile Answers by Mallikarjuna_G Questions by Mallikarjuna_G

• Aug 10th, 2013

For Join, Merge and Remove duplicates, have data on links hash key partitioned an sorted on Key columns specified. For lookup - primary link needs to be hash key partitioned and sorted and reference link has to use entire partition method.

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

Suppose i am having a source file and 3 output tables and I want first row to be written to first table second row to second table, third row to third table likewise how can we achieve this using datastage without using partitioning?

Dheerendra

• Nov 14th, 2014

Use SEQ---> Transformer stage ----> 3 SEQ Files In transformer stage add constraints as Mod(@INROWNUM,3) =1, Mod(@INROWNUM,3) =2, Mod(@INROWNUM,3) =0

Pratheeksha

• Nov 12th, 2014

For this, one option could be :
Get the row number column from the source seq file, in the transformer use stage variable which is defined as below:

if mod(i/p col,3)=0 then
if mod(i/p col,2)=0 then
"2"
else
"3"
else "1"

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

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

RAM

• Aug 27th, 2015

Without using Pivot stage..
Source --> COPY
COPY --> Head(1) --> File1
COPY --> Head(2) -->Tail(1) --> File2
COPY --> Tail(1)-->File3
now merge all file1,file2,file3 --> Target.
Pls check it may work.

sai3689

 Profile Answers by sai3689 Questions by sai3689

• Apr 1st, 2015

Thank u abishek

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

Solve these with suitable logics in datastage

Input is like..

department_no, employee_name
----------------------------
20, R
10, A
10, D
20, P
10, B
10, C
20, Q
20, S

want result like

department_no, employee_list

Shilpa Banerjee

• May 26th, 2016

Use Pivot enterprise stage and select vertical pivoting. Also perform sort in the stage using the partitioning as Hash. Take Dept_number as group by column and Employee_name as Pivot column and the output will be in the form of Dept_number|Employee list. For example:
10|A|B|C|D
20|P|Q|R|S

Vijayashree HN

• May 11th, 2016

First sort the columns Department_no and employee_name in ascending order. Then use the stage variables. current=department_no result= If current=prev then result:,:employee_name else employee_n...

Answer Question  Select Best Answer

How to find rank based on salaries?

Input
------
sal
5000
5000
4000
3000

Output
---------
Sal Rank
5000 1
5000 1
4000 2
3000 3

Reddy

• Apr 1st, 2016

3 stage variables:
sal : stgVar1
((sal< >presal and sal > presal) or(sal=presal)) then 1 else 0 : StgVar2
stgVar1 :presal
1 :Rank
if StgVar2=1 then Rank else Rank++ :RankVal

Ram

• Mar 28th, 2016

Src-->sort(desc)-->Trnsfrm(3 stage variables & generate Rank col) --> trg.

Transform Derivation for Rank column:
Initialize Stgv1,Stgv2,Stgv3=0
stgv1=Sal
stgv2=>if stgv1=stgv3 then stgv2 else stgv2+1
stgv3=stgv1

Answer Question  Select Best Answer

Suppose I have designed a Datastage job using sequential file stage,It will run in sequential mode.How can I run it it Parallel mode.

Suresh

• Sep 13th, 2016

Aloka, There are two ways in your example. In sequential file stage, number of readers per node and multiple nodes. These options will run an sequential stage in parallel.

Sandhyaram

• Jul 24th, 2016

In sequential file stage, we have two options No. of readers per node and reading from multiple nodes. We can run job in parallel mode.

Answer Question  Select Best Answer

Without using Sequencer how to design a Datastage job which normally receives input file to run. If tomorrow we will not receive any input file Job should not fail. It will run successfully without any warnings.

Ram

• Sep 6th, 2016

Hi Aloka,

you can achieve this by using unix shell scripting and schedule the job/script in any third party scheduling tool.

Thanks !

suresh

• Sep 2nd, 2016

Using JCL (Job Control Language) we can achieve this.

Answer Question  Select Best Answer

How to generate the occurrence no in out put file for the respective no of records in input file
I need a count in the target file how many times the same record is available in input file.

INPUT
-----

ID NAME LOC

20 B Y
10 A X
20 B Y
30 C Z
10 A X
10 A X
20 B Y
20 B ...

Aloka

 Profile Answers by Aloka Questions by Aloka

• Jul 22nd, 2016

Thanks Sri for your reply. After using 3 stage variable in xfm we can generate the count of the respective record.But after that i need no remove the duplicates to get the unique respective record in...

Sri

• Jul 20th, 2016

First sort the incoming rows by ID, NAME and LOC.
Then take three stage variables in the transformer

StageVar=inputcol
StageVar1=Stagevar
StageVar2=if StageVar=StageVar1 then StageVar2+1 else 1
map the StageVar2 to the output link column

Answer Question  Select Best Answer

1. What is the difference between Oracle connector stage and Oracle enterprise stage.

2. If we can achieve Oracle enterprise stages task using Oracle connector stage then why Oracle enterprise stage exists?

Siva

• Feb 3rd, 2017

Oracle connector having test connection. Ie plugin which is not Present in the enterprise state

vibgyss

• Aug 24th, 2016

2) Ans: min of 3 stage variables are required according to my view. example: if the source has two columns cid, address. we want to remove the duplicates in cid, our job design follows like below se...

Answer Question  Select Best Answer

Details:
Col
-----
C1
C2
C3
C4
C5
C6
C7
C8
C9
C10

we want to generate output like:
Col1 Col2 Col3
C1 C2 C3
C4 C5 C6
C7 C8 C9
C10

Can anyone please help me on this scenario?

Hemant

• Mar 4th, 2019

Use below constraints in xfm to move the data into 3 different columns. Make the xfm partition to run sequential.
mod(@inrownum,3) = 1
mod(@inrownum,3) = 2
mod(@inrownum,3) = 0

This will move first record to first output file, second to second and third record to third reference link.

prashant

• Nov 25th, 2018

Partion by Range

Answer Question  Select Best Answer

How to load the different data files in single target table using one data stage job? Files are having different name and data but target table in static.

Zeeshan

• Dec 11th, 2024

Merge the different input files into funnel stage and load it into target

Hemant

• Nov 17th, 2018

If the input file has same metadata and matching file name pattern, then 1. Set Sequential file Read method property to "File Pattern" 2. Provide File Pattern Else, if different file name, then sp...

Answer Question  Select Best Answer

If the paralle or seq job do not have configuration file..will it run successfully or not. ( If the job throws any error if yes what type of error it will be)

Somnath

• May 23rd, 2024

Without Config File the job wont even compile

Deepthi

• Aug 14th, 2022

No.it doesnt run

Answer Question  Select Best Answer

Default cache size is 256 MB. We can incraese it by going into Datastage Administrator and selecting the Tunable Tab and specify the cache size over there. 

Balaji

• Jul 12th, 2007

The default cache size is 128 MB. This is primarily used for hash file data cache in the server.  This setting is only can be done in Administrator not in job level. Job level tuning is available only for Buffer Size.

harshita

• Mar 29th, 2007

Default size is 128mb and we can change cache size in job properties for particular job and by going to tunables in Administrator for all the jobs across project.

Answer Question  Select Best Answer

By using "ExcecSH" command at Before/After job properties. 

anbalag

 Profile Answers by anbalag Questions by anbalag

• May 9th, 2008

You can specify the ExecDos Prompt in the after or before job routine.

vijay

• Nov 3rd, 2007

Select the EDIT tab in the toolbar-> choose job properties-> select the job parameters->choose the Before/ After routines ->select the EXCESH command

Answer Question  Select Best Answer

Config file consists of the following. a) Number of Processes or Nodes. b) Actual Disk Storage Location. 

Venkat Poonati

 Profile Answers by Venkat Poonati Questions by Venkat Poonati

• Mar 29th, 2011

1. fastname-----usually networkname,It is physicall node name,That stages use to open                    ...

aladap12

 Profile Answers by aladap12 Questions by aladap12

• Jun 26th, 2009

Biggest strength of Datastage PX is its configuration file.. Datastage engine learns about size and shape of the system by reading configuration file.It contains Nodes and resource available for running the job.

Answer Question  Select Best Answer

Rekha

• Jul 21st, 2007

* The issue that i faced with datastage is that, it was very difficult to find the errors from the error code since the error table did not specify the reason for the error. And as a fresher i di...

hanug

 Profile Answers by hanug Questions by hanug

• May 7th, 2007

1. I feel, the most difficult part is understanding the "Datastage director job log error messages'. It doesn't give u in proper readable message.2.We dont have many date functions availa...

Answer Question  Select Best Answer