DSXchange

Hi,
I have to FTP a zip file. I was wondering if it is possible through FTP Stage? Pls help me out in this regard.
Also can we FTP multiple files through FTP stage?
This question might be asked previously. Sorry if I'm duplicating the same as I'm new to Data Stage.

Thanks & Regards
Pinkesh

Hi, It is required to dynamically pick columns (headers) from a particular file based on some condition. Again the file name is also dynamic ( "xyz"+ID+MMDDYY). ID and MMDDYY will keep on changing. I have to pick ID from the file name and attach it to the selected columns. For example : Fi...

Hi, It is required to dynamically pick columns (headers) from a particular file based on some condition. Again the file name is also dynamic ( "xyz"+ID+MMDDYY). ID and MMDDYY will keep on changing. I have to pick ID from the file name and attach it to the selected columns. For example : Fi...

It is required that one file is compared with another one (Master File) and we have to get the Delta Records i.e. records which are either new or changed. Can anybody tell me which stage to use Change Capture or Difference and why? As I am new to Data Stage I am little bit confused. Any help in this...

It is required that one file is compared with another one (Master File) and we have to get the Delta Records i.e. records which are either new or changed. Can anybody tell me which stage to use Change Capture or Difference and why? As I am new to Data Stage I am little bit confused. Any help in this...

Thanks Amos. Appreciate if you please tell me how to use these methods. Atually I am new to this Data Stage tool. Again thanks a lot for your time. Regards Pinkesh Pinkesh , There is no built-in mechanism for such statistics in Datastage but there are methods that you can use to write it yourself su...

Thanks a lot for your information.

Is there any simple way to get these results for ex. to store the counts in some variables (i don't know where) and then in an after job subroutine we can write a shell script providing these values?


Regards
Pinkesh

I am currently working on Datastage 6.0 with Parallel extender. It is required to merge 4 sequential files based on a key value. For ex: Structure of File 1 : EmpNo, Name Structure of File 2 : EmpNo, Dept Structure of File 1 : EmpNo, Age Structure of File 2 : EmpNo, Salary I have to merge these file...

I am currently working on Datastage 6.0 with Parallel extender. The job requires to produce report in a text file with the following format stating the number of records processed, number of records rejected ( rejection can be based on business rules) and the number of records passed to the next job...