I want to check the status of the job (whether it is executed or not) through a UNIX shell script. Is there any way in DS where I can fetch only the status of the job?
You can use JCS (Job Control Script). In this you have to pass values through parameters. i.e., job name, path of the source file and target file, etc., After this you have to run the JCS from UNIX.
As Ray is telling, you have to flatten your input file. Means, you need to update your metadata by creating new columns. (As many times as it is occuring). I have faced the same challenge before and I got flattened input file and the new metadata.....
Hi... In Server 7.5x2, if you are using OCI, RDBMS or any other Database stages, you can join two tables using SQL query. If you are using sequential file or any flat file, you can do all the join types except right outer join by using a transformer stage. Coming to Sorting, there is a sort stage. A...