DSXchange

Das, Resetting depdends on the way you are calling the job for these 10 files. How are you calling this job for 10 files? If you are calling through a job sequence, then for that job activity just set the run mode to Reset if required, and run . There are many options available for resetting like us...

In your query, if you add order by clause before the union operator then I think it will change the order of output. In DB2 at least it works like this. So a query (select * from emp where DeptNo=10 order by empno) UNION (select * from emp where DeptNo=20 order by empno) , will not give the output i...

While reading the value how are you reading it? in char or decimal? From the post it seems you are trying to store this value in table using DB2 table. Instead of using normal Iconv as Iconv(20061001,"D"), why dont you use the full format i.e.Iconv(inCol, 'DYMD[4,2,2]')? Try this and let u...

As data is going to target, it depends on record size in target and no. of records. So approx (record size * total records).
If you are asking about the scratch space required then is would be depndent on the physical memory available for the job in addition to what Kumar_s has mentioned in his post.

To use this oprator you will have to use the transformer stage.

This is a bit new to me. Can you please share the answers to the following questions? Have you written the OSH script directly i.e. using OSH command from unix? What's this mainloop code and code following it, where u are saying compile and run the code? Where are you storing the transformer code an...

But why you have this kind of requirement? Is it just an interview question or you have some requirement due to which you are asking this question?

Row buffer when set to 1, instead of storing data to be inserted/updated/deleted, is sent to the table directly. When u have buffer with size more than 1 say 10, the rows will be stored in buffer and then 10 rows will be stored in buffer and then they will be sent to table. The buffering and commit ...

Kirtikumar - I'm not sure what you mean by that, since the design phases don't get affected by the data volumes. ... Arnd, normally when we decide whether project needs to be developed in PX or server, we consider the total number of rows that will be processed in the warehouse. Few of the project ...

One more thing, when you have to post some data like tables or job design use the code option which allows to use tabs n spaces so that tables will look like tables.

Are there two problems? From the post it seems u have two problems. First The job is loading the data with the nearest tags. To me it means, for the second row (or other rows than first), it is always reading nearest tags data instead of correspoding data from row. So for XML you have mentioned, are...

ray.wurlod wrote:parallel job startup time has been markedly reduced

Hopefully this will release impact on designing PX or server job depending on total number of rows to be processed.

Instead of the server shared container, check if the sparse lookup can be used. Sparse lookup allows you to fire queries at runtime. So you have to define Table_A as reference link with key columns mapped to QADATE. Then in SQL in TABLEA, add the query which will have range condition. But keep in mi...

I had heard sometime back that they have migrated repository from universe to DB2/Oracle.

Have they kept the universe as it is for this 8.0 version then?

Not double if you check it now!!!

At least 5/6 times you have posted this. It will increase your headache as you will have to look these many posts for this.
Type n search the forum for this warning and Ray has answered in first post.