DSXchange

Are you expecting your input files to come in ad-hoc while your job is executing? If not, you could concatenate your files using operating system commands prior to processing using a command stage in the sequence.

Please search the forum. You could use a BASIC transformer or alternatively use the convert function

You said one transformer - are the target file and the hashed file being populated from the same transformer? In that case, the first time a new key value is encountered it would not already be in the hashed file and will get written to the hashed file & target at the same time. The fields that ...

suryadev, as suggested by Andy - you should try command line ftp from your test UNIX machine. Google for 'unix command line ftp' and you should get all the examples you need.

Did you check the contents of the generated command file ? Please check any paths in the following command file are correct, and if necessary adjust the 'dssendmail_template.txt' file in the project directory. Contents of command file: C:\IBM\InformationServer\Server\DSEngine\bin\dssmtpmail.exe -fil...

As craig suggested, use something like the below assuming your data is the first field in the space delimited string and there are no leading spaces

You can use the Java Pack. More details at http://publib.boulder.ibm.com/infocente ... apack.html

Please post some examples and the derivations that you used.

29. how do u reduce warnings

Now that cant be an actual interview question

I suppose I could also split up the pair, rename columns on one link, join the records back on the key and then compare each of the values in a downstream transformer/modify stage. Would that be the best way to do it?

Hello, We currently get pairs of records from an external source where one is sort of a primary record and the other is secondary and we need to dedupe then based on key columns. We would need to pick a value from the secondary record iff there isnt any present on the primary record. An example is b...

Is there anything specific in your .profile that allows your script to be executed manually? I am not sure if your profile is sourced when you kick off any script through ExecSH. You may have to add some environment variables to dsenv. People here may be able to help a bit more if you posted your sc...

When your job aborts, what is the generated SQL and error that are posted in the log?

Any metadata differences between the column(s) being dropped and the ones that are not? Are the rest of the columns getting the right values or are they getting skewed/mis-mapped? Do you have any message handlers defined in your production environment?