DSXchange

Hi gbusson.
I think your solution would work with a non-large dimension...
As soon as the volume will grow... the performance would be brutal...

But good hint.

Hi Mike.
I just heard that a new stage will come up in the next version of Datastage... it's called Lookup Range... Maybe it could help you with your problem...

Maybe you could contact an Ascential's sales rep...

Math

Hi mczern. Type 2 slowly changing dimension is really common in the data warehousing world!!! If the data you're loading correspond to current data, it's easy... all you need to do is extract only the current image of your dimension and lookup against the key... in other words, in the SQL statement ...

Hi. I have a quick solution for you, but before, I just want to make sure that you cannot do it by using a SQL statement... Is you Date from the first job is in a different database as the SQL used in the second job??? Because, if not, there is probably a way to do it directly in a SQL statement wit...

Hi Thiru, In you DB2 stage, set the Write method to UPSERT. But be aware... even if the Datastage's documentation says that it does an Update first, and if the row is not found, an Insert... it does not really works this way... It first does an Insert, and if it fails (due to a unique constraint or ...

Hi From what I understand, the problem could be a mix of Oracle and Datastage PX... What is an Oracle Deadlock exactly: It is when 1 session make a change on a particular row and another session (not the same) try to make another change on the same row... but the change will not be applied until the...

Hi. Maybe you could check the buffer pool size in DB2. I had a similar problem before, everything on the PX side was fine, but it seemed that DB2 was unable to take more than 10 000 rows/sec... which was very bad... Then we increased the Buffer pool size and the performance increased significantly (...

Hi arasan. First, you must know that Informatica is a company... not an ETL tool... Power Center is the Informatica's ETL tool (even if we use to call it Informatica). In fact, both are great tool but they have different prose and cons. Personnaly, I think Datastage EE is a lot more performant... Bu...