DSXchange

I added the reject link to OE stage but where to set row limit to 1

Hi All, The requirement is to insert records into a table from a file. Before inserting into table I have to get the maximum value of the primary key. Then i have to append the records into table incrementing the value each time. For eg: The table structure is: Col1 Col2 00000 unknown 00001 gasoline...

hey, I got the solution.

I used the below derivation:

If Len(AspCodeCountSVar) ='0' Then AspCodeCountSVar Else Str('0',5-Len(AspCodeCountSVar)):AspCodeCountSVar

where AspCodeCountSVar contains the value after adding 1.

Hi All, The requirement is that I have to select the max of column value from a table and the add 1 to it and insert the new record. The column is varchar(5). So if the number after adding 1 is less than 5 digits then, zeros should be added before the number to make the field of 5 digits. For ex: Th...

Thanks a lot for clearing my doubts.

Sorry, I am not able to view your full answer.

Some premium content button is displayed. Could tou pls tell how can I view your answer

Hi All,

Could you pls explain what's the difference between Dynamic RDBMS and ODBC and OCI Loader. Also which stage is preferable and when?

I have used only Oracle enterprise stage as of now so dont have any idea about these stages.

Will it be faster using Dynamic RDBMS instead of OE stage?

Thanks

U can try this function;

YearFromDate(CurrentDate())-1

Thank you Sir,

It worked.
Such a small thing and it created a havoc.

Can you explain me what's the difference in writing Trim(Variable[from,len]) and Trim(Variable)[from,len].

All are VARCHARs

Hi All, I have to give one condition in transformer. I am using a stage variable to do this.But the job is getting aborted because of that particular condition.I am not able to find out whats wrong in the below condition. If Trim(Move_Xfm.Make)='Chevrolet' And Trim(Move_Xfm.Model)='Impala' And Trim(...

Hi All, I an trying to use Change capture on 2 tab delimited files, then doing a lookup with 2 tables, then using a transformer and then loading into another table. When i ran the job, it got aborted giving the fatal error as : Fatal Error: Destination "transfer0.Series" is already bound. ...

Hi All, I am using Change Capture Stage and given the option"Explicit Keys Explicit Values". Job is running fine but I am getting many warnings (one for each field which is used in Change Capture). Change_Capture: When checking operator: Defaulting <field_name> in transfer from "befor...

Hi All, I have a scenario where I need to compare 2 tables say for eg: table A and B, based on a key column. If the record with key column is not in table B then I have to insert that record into table B. I can do this in 2 ways: 1) By using a select query in Oracle Enterprise stage and then passing...

Thanks,

You are right. The records were dropped because there was no null handling being done. I used a transformer in between Change Capture stage and sequential file and handled null. Then it worked.