what are roles and responsibiliteies of an ETL developer/designer?
Printable View
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.
[QUOTE=nagakalyan;32915]As an ETL developer we have extract data from source and read data into target based on the functionality[/QUOTE]
^^+1
extract data from various source stages, perform appropriate transformation as per the requirement and load the data into a datawarehouse.....
[QUOTE=mallikharjuna;32812]what are roles and responsibiliteies of an ETL developer/designer?[/QUOTE]
ETL developer develop the ETL mapping or jobs to populate the data from source to target. So we can say ETL develper is the technical person who design the ETL mapping in any ETL developing tools like Informatica, datastage etc.
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