Page 1 of 1

Extracting bulk data

Posted: Wed Jan 09, 2008 11:57 pm
by SHARAD123
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

Posted: Thu Jan 10, 2008 12:16 am
by raj158347
Please specify what is the problem using folder satge ..are counting the records in the files.

Posted: Thu Jan 10, 2008 12:33 am
by chulett
First suggestion would be to ask a question.

Posted: Thu Jan 10, 2008 12:40 am
by sachin1
hello friend,

my question is how are you going to segregate records in file, when you read all files in directory in one go.

becuase for folder stage we have only filename(key) and Records columns to work with.

Posted: Thu Jan 10, 2008 12:50 am
by SHARAD123
I ve used row splitter to split the records accordingly... Now the prob is to count the number of recors in each file