DSXchange

Hi All, I am having a requirement which need to be implemented in Datastage. A source file is provided to us which is Java encrypted we need to decrypt it apply transformation logic and again load data in same encrypted format in target file. Encrypted formula is provided to me. Q1 :- Which stage I ...

Execute Command Stage will be an option for this logic to implemented. Every time output value will be over written to existing file with new value concatenated to it.

Mainframe file(EBCIDIC) should be read with Complex Flat files, because this stage can handle decoding of Compressed and non- compressed fields based on Copy Book provided to CFF stage. Out put will be in ASCII format over which trannsformations rules can be implemented. Yes you can recd (Pile) deli...

It Checks only alphanumeric characters

Link :- https://dtdctw99.tdbank.ca/infocenter/i ... ditor.html

Use Monitor Tab over concerned job to verify which stage is taking more time, then it can help u in analyzing logic's implemented.

Please check while exporting whether you have checked Include dependent Items ?? It is suggested to uncheck this option if you are taking export of only jobs. You can check Exclude read-only items options.

A SIGSEGV signal is caused by an invalid memory reference or a segmentation fault. You are probably trying to access an array element out of bounds or trying to use too much memory. So what transformation logic is implemented in Transformer ? Is any Surrogate Key being generated or some thing like t...

Hi

Try to Test Connection as well as Try to view data in both Source and Target stage.

Hi

You Can Write a Small Server routine using "DSRunJob" command which will fetch last run Job Status and based on status you can write Message in Status Report. This routine will be embeded in Loop it self only.

You Can Use
sed 's/Old-Value/New-value/g'