wht is full process of Information source to target
just like stg to productuon and development
Answer Posted / krishna
Initially data comes from OLTP systems, of a company, which
get loaded into a database or flatfiles with the help of
legacy systems or any pre defined methods. from here data
is transferred to the staging database applying business
logic with the help of informatica or other ETL tools. at
times stage to target is also loaded using informatica
mappings. these are transferred to another QA(quality
analysis database) in XML files. from there deployment is
done onto the production environment.
Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What is an expression transformation?
How to extract sap data using informatica?
What are the various types of transformation?
What are mapplets?
What is intricate mapping?
What is the function of look up transformation?
Different sorts of metadata that stores in the storage facility?
What is a filter transformation and why it is an active one?
How to handle decimal places while importing a flatfile into informatica?
What is the surrogate key?
I have a flat file, want to reverse the contents of the flat file
What are the types of data warehouses?
What is a joiner transformation and why it is an active one?
differences between service based and product based?
What are the tasks that can be performed using sq?