DSXchange

Or rather than setting null in transformer, assign some default value like 0000-00-00 00:00:00 (If it accepts without any error) and assing the same value in NullableFieldValue option Properties tab mentioned by robinson. Which will assign Null to that field value. Yeah... even I tough of the same.....

Have you tried searching.
Start with this. And get back if you still find it difficult to trace out.

As the log says, the actual data length is more that what you have specified in your OCI stage. Here you need check, which column metadata is different from the specified one.
Start with any Date of timestamp field if you have any.

You will have single job with single executable, but you can instantiate different instance of same job using different Invocation Id passed during run time. Its basically to reuse same set of code multiple times for several input. Pls go through the given document, or search the forum to get full d...

Thats true, Production Manager will have full access including Protected project. Operator will have only runtime access. May I know, where are you stuck now?

Though the output should not be exactly as you expect, it should be following Expected Actual B,C B,C C,D C,D D,E D,E E,F E,F E,K E,F E,L E,F F,G F,G F,H F,G H,I H,I H,J H,I M,N M,N N,O N,O N,Q N,O O,P O,P Q,E Q,E Q,R Q,E The problem was only during cross product. But join should do cross product pe...

Auto partition is chosed by default. Where Datastage decides the best suitable partition based on the down stream stages and its operation.

You have options to set DIRECT / PARALLEL command to set TRUE / FALSE using this variable. By using this variable you (and without using the Index Mode options) you can load the Tables which has index in it. If you want to load through index, you need to specify DIRECT=FALSE. If you need to run the ...

You can use the same sequential file with the name of the pipe mentioned in it. If you read one record, the next record will be available to read. And you can read it periodically, as the data will be available in the pipe given by your Java stream. Windows too have named pipe option. You can check ...

What is the value of APT_ORACLE_LOAD_OPTIONS given in Adminstrator client?

My Bad... yes not Shlash '/' but Back slashes '\'.
Where you able to access it now with '\'?

Degree of parallelism is defined by CONFIG file. Even if you specified as Entire partition and Crated only single node in config file, the data flow will be only in single stream. If you created 10 Logical nodes with single CPU and if you mention RoundRobin type, you can expect 10 steams to flow par...

Make sure you are giving right path.
Try with H:/DEV_ZGP0GSAS/Temp/NyScty_Ins_SctyDescADD.txt instead of
H:\\DEV_ZGP0GSAS\\Temp/NyScty_Ins_SctyDescADD.txt
Also make sure the user id have permission to H:/DEV_ZGP0GSAS/Temp/ directory.

Mode of execution is defined in each stage and governed by the Config file. So what ever you use, the other settings in each stage's Advance tab should take care of Partitions.

Hi Pavan,

Welcome to Dsxchange :D !!!

Both option works. If you have dsadm you have the full access.
If you have Operator role assigned to a user, it will have only the access to change the runtime informations.