DSXchange

Hey Synsog,
You might like this approach for your requirement.
http://dsxchange.com/viewtopic.php?p=41 ... d14#416088


Thanks,
Raja R P

Hi Sreedhar,

the after job routine in the below link will serve your purpose(a post by marpadga18)


viewtopic.php?t=138651



Regards,
Raja R P

Hi,
I do not know, if i am missing something.

But why can't we simply use a write mode 'Replace' option in Teradata enterprise stage.'Replace' would drop a table and create new one.


Regards,
Raja R P

Hi all, I am having a job sequence which is having a routine activity.The routine activity is as detailed below Routine name:ExecSHSilent Aruments: Name:Inputarg value expression: ksh /path/unixscript.ksh bteq1.sql where 'unixscript1.ksh' is used to trigger the 'bteq1.sql' while executing the job,i ...

Thanks for the pointer , Eric!!!! I am able to do that by oconv(iconv(Trim(Convert(@FM,"",ExeCommand.$CommandOutput)),"D-YMD[4,2,2]"),"DWB") where ExeCommand is a execute command activity where i am doing cat unixfilename I found the below link useful http://www.webelin...

Hi All, I would like to know a way to implement the equivalent of 'Weekdayfromdate ' function job sequence.Can this be achieved somehow in Job sequence? Basically, I have the date in 'yyyy-mm-dd' format in a unix file.In the execute command activity, I can use cat unixfilename and pull the date valu...

I know that's a lame question anyways... My apologies

There is no need of sort stage in front of the sequentail file.All it needs is specifying a sort/merge collector on the Sequential File stage input link.It will preserve the Sort.I tried this as well

Thanks,
Raja R P

Hi Ray, Thanks . Source 2 | JOIN---->sequential file | Source1 Please find that I removed the SORT stage from my earlier design. Even in this way , we can preserve the sorted order by specifying a sort/merge collector on the Sequential File stage input link,right? Regards, Raja R P

Hi all, I have got a simple job to review and want to confirm a thing. Source 2 | JOIN-->SORT-->sequential file | Source1 My Understanding: As the sequential file is not going to maintain the sorting, the 'SORT' stage in front of the seq.file is not required. Please confirm whether my understanding ...

Thanks for the suggestion Ernie!!!! I have checked the file permission and sub directory permision and have done 'chmod 777' for both the file and directory.But, no luck :( Also,another paraller job is able to write another seq file in the sme location. So belive, 'permission' is not the problem!!!!...

Hi all, I am developing a simple parallel job which involves a xml input file Sample input data =========== <xml> <ID>I7-1</ID> <ID>I7-2</ID> </xml> Job design: External source-->XML_Input--->SEq file Settings: External source: ========== Properties: source Method: Specific program(s) Source program...

HendrikB You could group the data in the sort stage (by TableName) and then use the created key change column in one stage variable in transformer. The syntax of <stagevar>: If KeyChange Then 1 Else <stagevar> +1 This should work like charm :) I didn't think of 'create key change' column and this is...

Hi Sudhana, You can design a job as below Source--->Sort--->Transformer--->Target Sort your i/p data based on the only input column you have. In the following transformer, you can use the three stage variables in the same order as below. 1.Column1Changed =>if link.COLUMN1 = PrevColumn1 then 'NC' els...

Ray,

This can be achived by using the mix of 'looping' capacicty of transformer and index() function.

Is this what you have intended/hinted?


Regards,
Raja R P

Hi All, My input data is present in Mainframe Flat files.So, I would like to know , is there a way to access Mainframe Flat Files in a Parallel Job .I chanced upon 'Complex Flat File Stage' in Designer.Is that the stage i should look into? If not, how do one normally access data from MainFrame Flat ...