what are roles and responsibiliteies of an ETL developer/designer?
what are roles and responsibiliteies of an ETL developer/designer?
As an ETL developer we have extract data from source and read data into target based on the functionality
explain in detail with example.
Hi..
This is kishore, i want parallel job interview questions in data ware house.
and some more information of parallel jobs.
I am very thankful to all the peoples who is giving answers to me,
Thanks u geek also.
Plz give answers as early as possible thanks to all
Paralle jobs: They are available if we have the enterprise edition installed.
They are used to process huge volumes of data using more resources.
(Mainly to load fact tables.)
Several parallel stages are available to perform the etl tasks like
Database stages,
File stages--dataset(substitute for hash file),fileset, lookup fileset etc..
Processing stages--transformer(functionality differs from server to parallel), aggregator, sort,cdc,difference,join(all join conditions and whern data is karge), merge&lookup(only inner join),surrogate key generator etc..
Hi,
Can any body tell me what exactly a stored procedure in datastage with example
Thanks