Thanks a lot Zhang /Khan !!
I want everyday file to load with snapshot not an incremental !!I want to have current day's data plus historical data for trending..
Would this option work !! Since i need everyday trending..
Data file will have nearly 1 million rows everyday......Is there any limitation
Any other suggestions!..