source table name A A B B B C C D In source table data like this but I want traget table like this name count A 1 A 2 B 1 B 2 B 3 C 1 C 2 D 1 pls any one one solve this........

Rams

• Jul 10th, 2021

Seqfile---Sort----Trans-seqfile
Sort Stage---KeyChange column true
Transfor- in advance tab set mode-Sequence
Create one stage Variable: Stagevar= if KeyChangecol=1 then 1 else Stagevar+1
Create on extracolumn in output give Stagevar=Newcolname

Gabbar

• Dec 8th, 2020

You can solve this problem by using two way 1. using a transformer 2. using aggregator and transformer By using 1st method you can create 2 stage variable i.e Stagevar1 and Stagevar2 In StageVar1 wr...

Answer Question  Select Best Answer

I have source like this a,b,c,1,2,3 ( All this in one column) I wanna target following below a,b,c,1 ( Ist row) a,b,c,2 (2nd row) a,b,c,3 (3rd row) Thanks in advance.

lalit

• Sep 12th, 2017

Its really simple Take one sequential file which contains data a,b,c,1,2,3 ( First line column name=false) Then take one copy stage with three output link and then copy a,b,c,1 at one output link ...

Ram

• Mar 10th, 2016

Hi Tulasi,
This is for you..

Src -->Trns (use Function Str(inputcolumn,@inputrow) --> Trg

Thats all !

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

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

how to design a job with incremental loading in datastage?

Divya

• Jul 14th, 2011

There are ways to perform the incremental load. While performing incremental load Pls take care of below points: 1. Retrieve changed records from last load run from source by using appropriate extract...

Answer Question  Select Best Answer

How do we pass parameters from UNIX? & How do we pass parameters by using UNIX shell scripting?

mcrao1

 Profile Answers by mcrao1 Questions by mcrao1

• Jul 11th, 2011

Hi Amulaswe can pass parameter in UNIX command by using '-PARAM'.syntax:     -PARAM parameter_name %parameter value%Example:    -PARAM business_date %20110711%      RegardsChalapathirao.MHCL Technologies( Malaysia)+60182296096.

Answer Question  Select Best Answer