What performance tuning experience
do you have? Explain
We can do performance
tuning experience by a making a note of time taken to execute for every task and
process in the ETL life cycle i.e, Making a note time taken by source ,
transformations, destination loading and used as many variables for sql
task and connection manager. Like I used to create a variables where I can
store all the sql queries there and save the connection manager in
variables so that the package will be more faster. I used only used
column not all the columns of the data by writing a where clause in sql . For
data conversion I used advanced editor in source rather then using data
conversion transformation. Etc.
No comments:
Post a Comment