DSXchange

Hi craig, I changed my sequential file to no quotes and i used trim function which is Trim(Convert(@FM,"", Execute_Command_20.$CommandOutput))="UnMatched" but still the same output the log is seq5..JobControl (@Execute_Command_20): Executed: type N:\DSLink127\outputseq Reply=0 Ou...

Hi craig, the log is seq5..JobControl (@Execute_Command_20): Executed: type N:\DSLink127\outputseq Reply=0 Output from command ====> "UnMatched" The summary of the sequence is as follows eq5..JobControl (@Coordinator): Summary of sequence run 14:34:59: Sequence started 14:34:59: Job_Activi...

Hi chulett, I apolozize for asking you these many questions as i could able to give type and file name i could retrieve the value but at the trigger i gave the expression what you said earlier which is "Convert(@FM,"", Execute_Command_20.$CommandOutput)="UnMatched" with expr...

Hi chulett , Can you please tell me as what should i give in Command. i mean you told that Command is type that is should i give a folder name or what is type i didnt understood and parameter i gave file name and Command i didnt give anything.what is the type that iahve to give in Command and in the...

Hi chulett, when i used execute command stage to type file name .my file name is N:\input and when i ran i got the error which i mentioned.in execute command stage , execute command there are two options which are command and parameters and in command i gave my file name.is that right what i did tha...

hi , When i give the filename in command execute stage and gave the code which had provided earlier .when i run the job i got an error saying that seq3..JobControl (@Execute_Command_20): Executed: N:\input Reply=1 Output from command ====> 'N:\input' is not recognized as an internal or external comm...

hi what should i give in place of StageName.$CommandOutput as i stored the value in file and has taken the file name in Command stage, but in Command stage we need to give a .bat file or command right?Can you tell me what should i give in place of StageName.$CommandOutput.i am new to the datastage s...

Hi chulett , Can you explain me in detail as to which stage i need to use in Sequence job and i can populate the status in sequential file as to matched or not matched, but how to send an email ,i can use notification activity stage to send an email , but wat is the condition i need to give in job a...

hi everyone , I had a job in that at the target i had a column which states whether the data is matched or not based on the source1 and source2 data.If both the source data matches it states in the target for one of the column as 'Matched ', if not 'Unmatched'.So i need to send an email if the data ...

Hi Everyone , I am planning to take datastage certification 8.x. And i dont have any idea of what kind of questions that come and what should i mainly concentrate i mean on what topics should i concentrate in order to pass the exam.And if there are any dumps available ..can anyone provide if not can...

HI everyone, when i run a job with some transformations ,everyting is working fine .i am getting a warning as jsControlTie1..xfm7: ORA-00001: unique constraint (CSS.PK5) violated so i am unable to load all the records in the table. please can any one suggest what should i do in order to get rid of t...

Hi ,

can you what should be the logic as when i have same business keys it is not able to do updates ..can anyone tell me what should be the logic in order to get rid of this issue?


thanks in advance

The only possible issue is that you're not setting the flag to 'N' in the expired row during your update process. ... well , when my source have data where the business keys is unique i.e. different busineess keys for each record so when i run the job it is doing both the updates and inserts based ...

What 'update action' are you using on the link that should be updating? I'm guessing it's not set to update. ... I didnt understood what you mean , but i am using update 'exisiting rows only' in the target database and in the transformer i am using the update condition which is business keys should...

Hi everyone , I am having one more issue as when my source has same business key but with different values in other fields.then when i try to implement scd type2 , i couldnt able to update one with current indicator as 'Y' and one with 'N' instead both are inserting with 'Y'.say for example if i hav...