DSXchange

Thank you qt_ky.

I've seen many times the Lookup stage designed with Sort on both links, the input and the reference link , that I'm wondering if the best practices changed on this one ! I'm talking about a Normal Lookup with the Input Hash Partitioned on Keys and the Reference Entire Partitioned. What would be the ...

The right answer is that with SQL Server we don't really need a Sequence Generator or State File or a database sequence , we just need to add to the table the IDENTITY column which will auto increment for every record inserted. And to use that with the SCD stage just let the Surrogate Key option bla...

I have another issue now ... after taking Ray advice and using SQLServer Enterprise stage the job is updating the dates and everything , but the SCD stage doesn't compare for real updates.

Could anyone help me with any ideea ?

One more question please , did you used all the build-in functionalities of the SCD stage ? like "Auto-generate Upsert SQL" ? Did the stage compare the fields by itself ?
I just noticed that the stage is updating the the SK !

I'm trying to use the SCD stage with an ODBC connection, in the most classic way , and the result is that it doesn't update nothing , keep inserting the records. Can anyone give me any idea where to look for the issue ? I suppose is another incompatibility between DataStage and Microsoft ..but I nee...

I'm sorry I wasn't clear about the issue I have .... I'm looking here to have the confirmation if our installation has an issue or is simply like that, because in the <Database Type> drop down list, I have options only for DB2 and Oracle ? I build the classic , standard job to create a sequence (the...

Hi Ray ...thank you , but I don't have this option.
I have only DB2 and Oracle in the list. I use DS 11.5

How do I generate surrogate keys using a SQL server sequence ; and use it with the slow changing dimension stage ?

I'm trying to use 2 vertical pivot stages one after another and I have an error that doesn't make sense to me. Please let me have your opinion, what might that signal here ? file-->pvt1--->pvt2---> file pvt1(Array size 4) col_1_key group by col_2_key group by col_3_key group by col4 pivot pvt2(Array...

The issue was the buffer not the number of tables. After I've increased the buffer and the administrator put some indexes on the tables keys, the query worked well.

Hi Ray : Yes the query runs perfectly from another tool (SQL Query Manager tool) I can say definitely that ODBC doesn't handle more that 3 join tables. I tried another one ; works with 3 tables but not with the 4th one Select count (*) FROM TABLE_1 inner join TABLE_2 ON tbl1.key = tbl2.key inner joi...

In fact doesn't fail , is just gone for the eternity ...

In the job I have

ODBC -----> Transformer (very basic transformation) -----> Difference( DataSet ) ------> Target table

I didn't involve the support by now, I just workaround by splitting the query and using Join stages.

These are my query joins : from table 1 lst inner join table2 ent ON ent.ENT_NO=convert(varchar(9),lst.key) and ent.CUR_FLG = 'Y' inner join table3 ctry on ent.key = ctry.key and ctry.CUR_FLG='Y' inner join table4 on ent.ENT_NO = convert(varchar(9),dps.key) and dps.FLAG = 'Y' left outer join table5 ...

I would like to know if there is any known limitation on how many table can I join into an ODBC connector.
It seems to have problems for 4 and more.