DSXchange

Hi i have to find the record count for the sequential file_1 which is generated by 3 different databases in a single job. by using 2 source as hash and other by source as sybase. And after getting record count from seqentail file1 i should populate in other sequential file field. And i tried using 1...

Thank you so much it worked out,

Similarly i have other selection cretria in which the Processing_month field should have the value of Last 12 month, counting back from October 31.

How shall i implement this.

Thank you so much it worked out,

Similarly i have other selection cretria in which the Processing_month field should have the value of Last 12 month, counting back from October 31.

How shal i implement this.

Thank you so much it worked out,

Similarly i have other selection cretria in which the Processing_month field should have the value of Last 12 month, counting back from October 31.

How shal i implement this.

Thank you so much it worked out,

Similarly i have other selection cretria in which the Processing_month field should have the value of Last 12 month, counting back from October 31.

How shal i implement this.

In one the text report which i am generating should includes only transactions with processing_date within the monthly reporting period. E.g. 20080601 to 20080630 for the month of June report. This is one of the selection cretria to generate the report using sybase. How shal i implement this and the...

C my requirement is that i have to extract data from different two databases requried fileds and also one more source is file as input. and i have to check for example File : File1 Branch & Account code Database table1 branch_cd & account_cd so i have to check file and tables columns are equ...

First of all let me thanks u for ur rpy...
but how we implement this in vertical pivoting... I am new to datastage so plz advice me

Can any one suggest me how to convert rows into column. i have addresses field in the source with an seq_num as key column in that table. the following i have illustrate how the input is and my output should look like INPUT seq_num address1 1 no 291 2 I st floor 3. Nandini Apartment 4. shivajinagar ...

Thanks,

The below is the query :-
max(case when tda.addrs_seq_nbr=1 then tda.orgnl_addrs_ln_txt else null end) orgnl_addrs_ln_1,

will the pivot stage help me out in this..

Can any one suggest me how to convert rows into column.
i have implemented as max( case.....). but there is problem in executing so plz help me out in this

Hi, I have a problem in datastage server job-memory issue.Please find below the detailed description: There exists a job which has many routines involved in connecting to the SQL Server 2000 database.Apart from that this job calls other 10-12 server jobs in sequence.It is told that the main job is c...

Hi All, I have one controller job, a Job and routine. I executed job(FORMAT_JOB) by controller through routine. this is working fine for last one year. Yesterday controller job aborted with below error. CONTROLLER..XfmRunFormatA (fatal error from DSRunJob): Job control fatal error (-14) (DSRunJob) J...

Hi Guys,

I am having one Macro that will convert seq file to xls file. Now I don't know how to use Macro in DS job.

Please give suggestion me how to use.

Thanks in advance.

Venkat

ArndW, I did not create any job using excel. I want to tell the requirements to client to connect excel. That is why i asked these questions. So now I understood from your answer that to connect with excel, DSN should be created and columns also should be defined . Thanks Arndw to spend your valuabl...