Extracting bulk data

SHARAD123 · Post by **SHARAD123** » Wed Jan 09, 2008 11:57 pm

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

raj158347 · Post by **raj158347** » Thu Jan 10, 2008 12:16 am

Please specify what is the problem using folder satge ..are counting the records in the files.

chulett · Post by **chulett** » Thu Jan 10, 2008 12:33 am

First suggestion would be to ask a question.

sachin1 · Post by **sachin1** » Thu Jan 10, 2008 12:40 am

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.

SHARAD123 · Post by **SHARAD123** » Thu Jan 10, 2008 12:50 am

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