Data Conversions
Page 1 of 1
Data Conversions
Hi Experts-
I'm looking for a solution for the below situations,
1 When the source file/table not available in the specified folder I need to stop the execution of my script (Sybase IQ) and the script should stop the ETL work flow/Job automatically.
2 When the source file/table contains error data say, the source table contains 20 records among which 5 contains error data. I need to have a script (Sybase IQ) in place which will remind me that only 15 records were processed and 5 were excluded for error table. In this scenario I need to send an email to the customer with the complete details automatically.
3 Once the Errored data was corrected and placed in a source location I need pick that table/file and need to carry the required process to create a stage table. Once the stage table creation was done which should trigger the ETL work flow automatically.
4 Once the Stage table created, I need to archive the source table automatically.
Please share me your Ideas will these can be achieved else I need to rely on my ETL tool?
Thanks In advance.
-Balas
I'm looking for a solution for the below situations,
1 When the source file/table not available in the specified folder I need to stop the execution of my script (Sybase IQ) and the script should stop the ETL work flow/Job automatically.
2 When the source file/table contains error data say, the source table contains 20 records among which 5 contains error data. I need to have a script (Sybase IQ) in place which will remind me that only 15 records were processed and 5 were excluded for error table. In this scenario I need to send an email to the customer with the complete details automatically.
3 Once the Errored data was corrected and placed in a source location I need pick that table/file and need to carry the required process to create a stage table. Once the stage table creation was done which should trigger the ETL work flow automatically.
4 Once the Stage table created, I need to archive the source table automatically.
Please share me your Ideas will these can be achieved else I need to rely on my ETL tool?
Thanks In advance.
-Balas
Balas- Posts : 11
Join date : 2012-04-26
Similar topics
» Looking for a Data Architect/Data Modeler for NYC Big Data Startup
» clickstream fact data coming in with different levels of dimensional geography data
» difference between data mart and data warehouse at logical/physical level
» Reporting table data repository vs. Dimensional data store
» Anti-aliasing time series data in a data warehouse?
» clickstream fact data coming in with different levels of dimensional geography data
» difference between data mart and data warehouse at logical/physical level
» Reporting table data repository vs. Dimensional data store
» Anti-aliasing time series data in a data warehouse?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|