DSXchange

Do a reset on the aborted job. You may find some usefull information on "From Previous run" log.

Do you want to know what is the difference between partition and sort? Patitioning key and sorting key can be explained by its name. Many freshers assume that, by performing partition it does sorting as well. Its not true. The key based on which the records are distributed to the available nods are ...

Perform a search on this forum, this has been discussed many times.
Search for "How do I remove duplicate rows from a data source?" in FAQ.

Do you have any pattern in which the folders should be moved or its just a number count. If it has any pattern, you can make use of "File Pattern" option available in sequential file stages to get the list of folders. You can limit the numbers using transformer. Deletetion can be accomplished by the...

Hi Vidya, Welcome aboard :D Type 2 is you want to add new rows to the target and retain the old rows with a unique Key. So simple surrogate key generator would help to maintain unique keys(Primary Key). For the concept of update/Insert, have a look at vincents blog here. m Do a search on "SCD type2"...

And it is not must to have entire partition on the reference lookup. Hash partiton on the key for both input and refernce like will do.

Hi Cetin,
Have you treid assigning a Null to a not null field in a transformer?

If you go through all the post, you may end up to replace that stage with Join-Transformer.

you cannot stop datastge from creating a 0Kb file if it is given as in output link. But you can delete the created 0kb (only if 0kb) from after job subroutine. It has been discussed. You can perform a search on it. Or filter it in a higher level, i.e., from Jobsequence with the help of parameter/Job...

Auto partition might have helped you in your case. But dont expect in all the case, if your expect presicse result.

Auto will do, unless you do a key based transformation (eg comparing current and previous records...) in transformer.

You could have just recompiled, with export-import.

Field 'pt_state' from input dataset '0' is NULL. Record dropped Reconfirm the output metadata of the transformer for pt_state column is nullable. If you source is nullable = 'no', check the RCP. Disable it. Esle change this column as nullable = yes right from begining and do a 'Force compile' and r...

Try not to partiton and to sort in Transformer, maintain Same as mentioned. Try using APT_COMBINALBE_OPERATOR to false. Or the same effect in the transformer. As mentioned, just do the required partiton in the funnel and maintain the same. Is there any key based specific operation going on in transf...

Selecting Datastage is good decision. But dont be specific on any tool. They come and go. Try to be experitised on different domains. If you are master in the doamains then you can play with any tool. Either you can expert you skills in domain (Business) or in tool(Technical). Both will provide you...