DSXchange

Best thing to do would be to have a after job routine. Some thing like Source table -----------Copy------------------Target Table | | | Copy Get the Link counts and write it into a flat file in the format as required

I understand that your req is to generate surrogate keys for the database.. The best way i think you can do it (alternative to sequence of database) is to design a shared container so that it will generate a surrogate key for the previous high value by using a transformer or surrogate key generator....

How can a date be in such a format..dmmyyyy :roll: From first look, your date format looks like a Julian date.(dddyyyy) where ddd is the nth day of that year. Use the Date and Time Functions in the Transformer and convert it into the format you need. IHTH Hi, I agree with krish. it looks like a jul...

Fix the first problem (Input "ACCOUNT" is not a value field.) first. The numbers showing in your Data Set are indexes to vector elements. Each element is of data type string[max=37] (which is how o ... Hi Ray, The number that were there in the dataset are not indexes, they are actual valu...

Hi All, When i trying to convert a vector to individual columns by using the Transformer stage, it is giving me the following error. Transformer_38: Error when checking operator: Input "ACCOUNT" is not a value field. Following is my job Design Row Generator -> Combine Stage -> Transformer ...

If you have having performance issues reading the large volume tables, check out the topic: http://www.dsxchange.com/viewtopic.php?t=100002&start=0&postdays=0&postorder=asc&highlight= I post some info there about how to setup a parallel query from DB2. Regarding your join, it sounds...

i. When you are talking to huge tables, try to INDEX it properly while doing a SELECT. Build and use proper indexes on your 40-70m records table. ii. Not pretty sure, but Hash partitioning may help you in this scenario.. If the two tables on which i trying to join are indexed properly(i mean on the...

Hi All, This is my first post to the group. Just wanted to know how to increase the performance for the join. My input data is around two million and reference link(for DB2 tqable is around 40-70 million. I see that join itself which is better alternative over lookup, is taking lot of time. To read ...