DSXchange

Change capture is in Enterprise.

Why not re-create the Target table instead of deleting. You can use bulk loader to load the target again.

Hi

You can enable it by job level. You don't have to apply this to your entire project.

Sorry Craig

I missed the substring....

Hi Parvathi Use Constraint in transformer and inside that type the condition (eg InputColumn = 'begin' Or InputColumn = 'end'). This will only allow records with your conditions. You can also have the same logic applied in your transformer expression using If clause. If InputColumn = 'begin' Or Inpu...

Hi

The Parallel Function already exist called NullToZero(FieldName). You don't have to create a new function.

Once you created the Function using Designer or Manager you must compile.

Seems like you don't have complier installed on your Windows system. Contact Ascential...(IBM)

Moderator

Duplicate post to be removed

Hi

don't post your questions multiple times.

Moderator could you remove this duplicate post?

Hi

do you mean Datastage reserved words. Please be more clear.

Use KeyMgtGetNextValue function to generate surrogate key in Server job.

Hi Karthik

Please do a search on Slowly Changing Dimension Type 2 you will get heaps of results to answer your question

Create user-defined sql query in the where clause assign a parameter with #month# and while running the job supply the month value. Oracle will then automatically does the magic...

First make the job to run without any error. Then post how much time it took to run the job... This should help ...

Ray is correct there is NullToZero function in PX.

Krithik you need to use the Trim function to remove the space and then apply NullToZero this should work.

Hi Datastage can be run in windows environment. You can install both client and server in windows. You can also install PX in windows. You have the same datastage administrator in windows in which you can use to administer. There are few companies uses PX on windows environment compared to UNIX envi...