DSXchange

There is just one command to run either sequence or job. One way out to differentiate between the two from unix command line would be based on their naming standards used. Normally all jobs would be named in a way different from the way sequence is defined. Based on the ETL naming standards, there w...

I made that changes to Force Parallelism to Yes. I tried running on 1 node and 2 node configurations, and it runs. But as Ray told, I will have to look into the remote server to see how many instances of conncetions are being made.

Thank You for the solutions

I still do not understand why a source with 230 million rows doesnt have a key column. And if there is no key, how do you define delta rows?

You can use a String Function like Count to see the occurence of @ to ensure its is an email string. I do not think we need any C++ routines. Try different string functions to see what would be better for your requirements.

Hi, I am using multiple URI's in FTP Enterprise Stage inorder to read different files located on a single remote server. The job works fine. The question is , if 5 different files are being accessed using 5 URI's from single remote server, does this mean that the stage will try to establish connecti...

Thanks Ray

Do you have an intermediate file to which you are storing the derived results before loading into the target table?
If then did you open that file and look at what is the timestamp being generated today. Might give you some insight.

Thanks Randall. Combining them in mainframe would be a good option.

Right now I am using FTP plug in stage. So I can read only one file at a time(could we read more?)
If I use FTP Enterprise Stage, would I be able to read multiple files at the same time by providing multiple URI's?

Try using Reject option in Lookup stage instead of continue. For the records which are coming from the Reject link, apply the necessary derivation by using a transformer or any other suitable stage. Then combine the results from both the links finally.

Hi All, I have a requirement to read multiple GDG's (versions) of a mainframe file. The current design I am using is to FTP different GDG's , combine them using a funnel and then write to a dataset. The question is , is there any way I could read the base mainframe file through an FTP stage, instad ...

Thanks Ray. The List of Modify stage functions pdf which you send is very helpful. I was looking at the 7.0 orchestrate manual for the string_trim and couldnt find it and then browsed the forum. This list helps.

Hi

Try this

targetcolumn:string[4] =Handle_null(string_trim(source_column),"xxxx")

It works for me

Hi Kumar,

The datalength is 38, sqltype is Decimal and Notnull

Thanks
meera

Hi Kumar,

For warning1. I tried that option, still iam getting the warning.

For warning2. In the target also i have as notnull.

Thanks
Meera

Hi My job design is Transformer (TRS) (key,a,b) | | lookup (LKP_ID)-----------> dataset (DS)(ID decimal(38,0)NotNull,a,b) ID decimal(38,0)NotNull ^ | | | oracle stage (GET_ID) (key,ID decimal(38,0) NotNull) In the oracle stage SELECT ID.NEXTVAL FROM DUAL where 1 = ORCHESTRATE.Key I am getting the fo...