DSXchange

Using FMT with code R0 will round your input. Is that what you really want. What is the datatype of both of your columns? Need to know the sql type, the length and scale.

What is the workaround. What was the problem that you had. This is a rare problem and would really appreciate it if you share the solution with us. Also, you can delete your other post referring to the same problem.

For exact aproximation (if there is a sucha word couple), refer to this post.

Welcome Aboard
Group by the key columns and provide Summation for the field you want to sum. This will sum up all the records corresponding to the grouping field in that particular column. If you want to add two columns you can do that in a transformer.

If time is of the essence then go for a database level join.

Is your source a flat file or a database table? If the later then do an order by in the source and get sorted data. If former then you can use the os level sort by providing the -T option with it to specify the temp directory which will be used to hold groups during sorting. If over all you have low...

I say if you think, ever, you are going to go close to 2 GB, you need to think about it. Now depending upon your time window and your database activity, you decide whether to go with a hashed file or do the join at the database level. If you have time window is large, go for a hashed file, if there ...

Well... you would do that to pass data between jobs. Usually, to pass something between stages, all you need to do is add that new field to the link between the two stages. Why make this more difficult than it needs to be? The other option is 'COMMON' storage. Or one of those five available @USERn ...

Yup, he sure is. Good to have you back Arnd.

Read your file as a unix file and load it to another file which is line terminator dos.

You can run the above query in your routine itself using DSExecute(). Also if your hashed file was created in a directory path outside the project directory then you need to VOC pointer to the hashed file before using the select count(*) on it.

Try a smaller commit size. Maybe 20K. If nothing changes, get your dba involved to trace whats actually going on at the database end.

Check for that file in your default project directory. Maybe its sitting there somewhere. Also, did you provide 'Y' for the property "Remove intermediate data file"? Try with 'N'. If nothing works then set Load Automatically to 'N' and then go to the control file directory and see if it really gets ...

True. This is because stage variables are stage specific. You need to set the user status in your first transformer and retrieve it in the second. Search for setuserstatus. Its been covered a lot.

Not possible. It will give you a message, something to the effect, "Job xxx is accessed by another user".