DSXchange

I did not understand the point you told

the ask is is there any way to pass parameters into sequence with out hard coding and not much disturbing existing sequence

I have a requirement,currently there is an audit mechanism in place which uses a single ETL Audit table for capturing the counts ,filename,path,rej path,table name etc. All above param values are hard coded into the Audit insert sequence job (which resides in the main sequence job);Now the requireme...

Hi,
I uses Datastage 11.5v and a requirement came to connect to Mongo DB to get data from an external source system.When I checked in Palette I could not find Mongo DB stage as well.

Could some one help me to understand how to connect to Mongo DB from datastage?

I believe the issue is with some invisible characters in the source file,requested new file to check,thanks for all the inputs

Hi ArndW , The deadlock issue got resolved as I put No Lock clause in the input query As I said,Target Tables dont have any keys or idnices defined and we cant do it as well Hi Kumar, What i meant to say "Duplicates loaded " if I load the same data again for the second time I believe no ro...

Dear All, for the last two days I am playing around with ODBC connector to load data My requirement:If the rows are already existing then update else Insert. Target DB:Sql Server Requirement constraint: Cant add primary keys or index in target DB as it is being already used in front end,hence no key...

Hi All,

I have a requirement to capture the CDC logs (ie: number of copy rows, number of rows inserted, number of rows updated/deleted) in to a table. Is there any easy way to achieve this?

Please suggest options.

Thanks Craig for the swift response but there is a small change in requirement if you see the above query, the value for field A should come from select query, B,C,D,E,F Values will come from a source file columns G,H will be again from transformer(Hard coded) The whole idea is there are some fields...

Hi all, I got requirement to change the below existing query in to a DS Job PFB the sample query INSERT INTO Table_Name (A, B, C, D, E, F, G, H) VALUES ((SELECT MAX(id) + 1 FROM id_table), '', 5, 'ABBEY', '', 1, 1, 'EFG'); How can I achieve inserting the first value(select query from a table) using ...

Thanks, I will try and let you know

Thanks Craig. As you suggested I have two links from transformer Link1: Constraint source count=target count then to target table with update audit table with target count and status in table is success Target DB stage Read committed,Record Count and Array size=1 Link 2 Constraint source count <> ta...

Thank you for the response. I am fine with first part you suggested.

"and only then abort the job if required"

Could you please specify how to implement above step?

Thank you for the response.But I need to write the table count to audit table and if count mismatches i need to fail the job also that is the req

Hi All, This is my requriement I need to compare file source count with target table count and write the both counts in to an audit table with status Success(If count are equal) or Fail on the other case and I also need to fail the job if count mismatch is there. The issue I face is,If we try to ach...

Thank you Ray