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


Please Help Members By Posting Answers For Below Questions

What is an expression transformation?

590


How to extract sap data using informatica?

607


What are the various types of transformation?

644


What are mapplets?

821


What is intricate mapping?

590






What is the function of look up transformation?

651


Different sorts of metadata that stores in the storage facility?

559


What is a filter transformation and why it is an active one?

560


How to handle decimal places while importing a flatfile into informatica?

719


What is the surrogate key?

638


I have a flat file, want to reverse the contents of the flat file

693


What are the types of data warehouses?

944


What is a joiner transformation and why it is an active one?

580


differences between service based and product based?

1565


What are the tasks that can be performed using sq?

614