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 the size ur source like(file system or database)? how many record daily come u r banking project?

1744


While migrating the data from one environment to another environment how would you manage the connections?

623


Explain the informatica workflow?

582


What are the different types of repositories created using informatica?

653


What is a mapplet/worklet in informatica?

680






What is the difference between informatics 7x and 8x and what is latest version?

539


How do you promote a non-reusable transformation to reusable transformation?

658


Mention some types of transformation?

602


Explain the pipeline partition with real time example?

649


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4308


how many types of dimensions are available in informatica?

559


How does the aggregator transformation handle null values?

695


How to update or delete the rows in a target, which do not have key fields?

650


expain about the tune parameters?

1877


Mention few power centre client applications with their basic purpose?

532