How to load data (key range) to 3 worksheets
How to load data (key range) to 3 worksheets in a single excel target? (Let me clear you, I had 3000 records data need to be processed in a mapping and to load the data 1-1000 recs into worksheet 1,1001-2000 on second....)
Reach me sriram_kumar @ oneindia . in
Re: How to load data (key range) to 3 worksheets
for this create the source partitoning and make three targets on the base of key range.In the session properties we can define the sql query with key range so tht each qualifier read only tht range of records and loads in to corresponding target table.
Re: How to load data (key range) to 3 worksheets
Thanks Reetasharma.
The concern is not about Pipeline Partition..but loading data into 3 worksheets of a single Excel Sheet.