DSXchange

Hi Ray,
Thanks for your response. Then my perception about sequential file was wrong. Can you please elaborate your explanation? Thank you.

Sorry missed most important thing.

Before applying the above logic, Please sort the data on the key column then apply above logic. Thank you.

Use this logic.

SCurrent: Link.input_key
SCompare: If SCurrent=SPrev then SCompare+1 else 1
SPrev:SCurrent (Default it to some empty value like "")

Thank you.

Hi Ray,
I resolved this problem with the help of DSSetUserStatus. Thank you.

Hi Ray,
Yes, all the parenthesis are declared correctly. This is the code which I have declared in "To" Field in the Loop Activity.

Trim(Convert(@FM," ",#Execute_Command_61.$CommandOutput#))

Thank you.

Dear All, This is my Design. Job1--> ExecuteCommand--> StartLoop 1. In Job1 I am taking count from a Database table and the same value I am populating into a text file with numeric data type. 2. In Execute Command I am performing TYPE path of the text file 3. I am assigning command output as Loop Fi...

Thank you so much Ray. You are a treasure of knowledge. Thank you.

Dear All, I have a question. Is there any way to return nature of the job type ( Example: Sequencer, Server job and Parallel job). Reason behind this question: We do have multiple projects in the production environment, and each project holding more than 1000 Jobs. For all these projects I am creati...

Thanks for your quick response. Yes, I did the same thing. 1. I copied "hOCC_FACT" folder and "D_hOCC_FACT" file into another directory. 2. I executed DELETE.hOCC_FACT command in administrator still i am getting the same error. "Verb "delete.hocc_fact" is not in yo...

Hi Everyone, One of my DataStage is aborting in production environment and it is throwing below error message. I am trying to generate a hash file from my job, Then this problem is happening. "GSO04_Occ_Fact_Load..tMap2: |GSO04_Occ_Fact_Load..hOCC_Fact.lhOCC_Fact: DSD.UVOpen "hOCC_FACT&quo...

Thank you so much Chulett. I am passing the Execute_Command output to a Before Subroutine as a job name to generate dsjob -report. With your suggestion I used below code in the job activity and it resolved my issue. Thank you. Code: Trim(EReplace(Execute_Command_18.$CommandOutput,@FM,""),(...

Hi Everyone, This is my sequencer design. Job1 ---> Execute Command ----> Job2 Job1 ---> In job1 I am generating one job name into a text file. Execute Command ---> I am executing "type path....file.txt". Job2 ---> I am passing the job name value as a parameter to the job2. The above seque...

Dear All, I created 2 jobs. Background Information: -- In my first job I am pulling all the existing jobs in the project into a .csv file, This job is producing almost all close to 1000 jobs information. -- In my second job I am populating a dsjob report into a control table. "Second job suppos...

Hi Ray,
Thanks for your information. Since, I am creating a run time ETL automation solution for my project. In that I want to include schedulers schedule time in a control table from there this question was raised. Thanks for your input this is sufficient for me to go further. Thank you.

Dear Talent pool,
Is there any way to pull the scheduled jobs information from repository? I already searched for the same in the forum but I didn't get proper information. If anyone gone thru this can you please share? Thank you.