DSXchange

Yes

Double click the derivation column and manually delete the derivation for all the columns.

Siva

This how datastage behave when we import meta data from the repository using load. You can always delete the derivation from removing from the tab. There isn't any setting in datastage to do this automatically.

Thanks
Siva

Explain a bit more to help you. Do remember spaces are considered to be values and not null. Check the length of those columns in the table.

Thanks
Siva

Well Ray must be knowing this. But my answers is not in immediate new version of datastage. Doing Aggregation in datastage Server depends on the volume of records you have as well if sorted you get the max performance. For smaller number of records you can use this stage and I normally use a staging...

The problem is not with datastage. The problem is the way you tell the datastage to do for you. If you are new first read the documentation given for Oracle OCI stage. Kindly enroll in Datastage course asap. While posting in the forum give enough information so that I will help the person who want t...

Read the documention for Temp tables in SQL Server.

You can create temp tables using datastage. But when the session is closed the temp table is also removed from the database. As long you can do it in one single session yes you can use it.

Thanks
Siva

Use Iconv(Arg1,"MCN"). This will extract only the numbers from the Arg1.

Thanks
Siva

Write those targets to a text file and then create a job to do your insert and update

Thanks
Siva

Check your metadate when you write to a file and check is there any transformation which transforms as string. Also check the metadata of the next jobs which reads from sequential file.

Post your findings

Thanks
Siva

bobby

While posting give us the full information with examples of what is your source and how you want your target to be.

Thanks
Siva

hi

search for insert/update discussion in this forum this was covered so many times.

Try not to do insert and update in the same job. Seperate the inserts and updates into two streams and then have a separate jobs to do update and inserts.

Thanks
Siva

Hi bobby

Don't do multiple post in this forum. Please wait for your post to be answered since not all the member are online at all time.

Thanks for your co-operation

Rasi

Hi

Do some fundamental programming course which you give the ideas of framing these logic inside this tool

Thanks
Siva

Search in this forum there were so many topics discussed about this.

Rasi

Is this error specific to your pc. Try doing the same in another machine.

Rasi