DSXchange

I tried a routine for that and the it worked..

How to do FTP(SCP) from datastage?? I got a sequential in my local directory, how to ftp it to someother system??

I used the last_day(field name) fn of oracle in the sql space n got the number of days..

I ll try out your ideas too..
thnx anyway..

Hi, Is there any way to find the total number of days in a month using the transformer stage?

I ve used row splitter to split the records accordingly... Now the prob is to count the number of recors in each file

Pivot stage is used in what conditions?
Could someone help me out!!!!

The scenario is to extract N number of files from a directory in a single go and then load it to a diff database. Also need to count the number of record in each file.


**I tried using Folder Stage