DSXchange

Thanks for the valuable suggestion. Tried same in the transformer stage with four variables but the output not same. Assign a stage variable 1 = cntvariable as 0 prevrec=currentrecord currentrecord={ the input from the source} SameRecChck=If the previous rec is equal to the current records increment...

I need generate the sequence numbers based on the same value in the data stage. Tried using the sequence number generator but it is create sequence numbers but not generating based on the same value. and also tried using the seq generating numbers in the transformer stage and that one also not worki...

|i, We are getting a binary file[delimited with "|"] as source. It is not giving as proper view data , While Reading the file using sequtial file stage, given options as EBCDIC with binary format in the stage. but we are not getting proper view data. Sampel Seq file stage view data - 10|ab...

Hi,

instead of writing a code any direct function is avaliable in the transformer stage. it will be easy to manage.

Searched in the forums did not get the relevent information.
Any help greatly appriciated.

Thanks -Suresh

Hi, i need compare the data and give the output in terms of percentage Source data empid,ename,eaddess,sal "1000","abcd","road7 stree2","1000" "2000","dddd","roadno2 streeno12","2000" Reference data empid,ename,eaddess,s...

Hi Sriram, If you are reading from a sequential file. Read as a complete row into a single column. in the transformer stage, StrVar1 Inputlnk.column:- StgVar2 str(Inputlnk.column,3) After transformer stage convert row into column based on the delimter "-" then use column import stage to sp...

yes all the tables are in same database schema and same server

Now the jobs is running avarage with 10records per sec. DBA happy with the indexes. datastage admin-enough space in the temp area. source data which is having 400000 records completed with in one hour. when we have 500000 records running 15 hrs. any checks need to request DBA /admin on this issue. a...

Thanks ray for the swift responce. First check we have done indexes on the tables. both are in sync. second data stage sctrach space. we have enough space. third check compared two jobs any change in the jobs(different environments). jobs are same. Any other check which we dont have access to the ad...

Hi, We have job delete data in 5 tables. Db2 stage type is DB2UDBAPI. |------------------------>targer table1 |------------------------>targer table2 | Source table ----->copystage------>targer table3 | |------------------------>targer table4 |------------------------>targer table5 The source data c...

Hi, I have a job which contains the following stages. |----------->delete cust_table (Based on 4 columns) |------------>delete prod_table (Based on 4 columns) DB2_source---------->cpystage--------> del cust_table (Based on 4 columns) |------------>del sales_table(Based on 4 columns we are using db2 ...

We have specified the below options in the sequential file stage. Record level final delimter=end Record delimiter=UNIX newline Field defaults Dlimeter=Comma Quote=double Actual process expected: i am sure i have to get the file with comma delimeter, so that i have used comma as field delimeter in t...

Source is the comma delimited file. Sample data: "Emp name","Empno","sal" "xxx","101","2000" "bbb","102","4000" "aaa","103","3000 I have given the below properties in the sequential fil...

Hi, I want to concatenate the three columns on the emp information. Source data ename,eid,eflag "abc","100","yes" "bbc","200","new" "cbc","300","old" "dbc","400","NA" output: ename...