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 the size ur source like(file system or database)? how many record daily come u r banking project?
While migrating the data from one environment to another environment how would you manage the connections?
Explain the informatica workflow?
What are the different types of repositories created using informatica?
What is a mapplet/worklet in informatica?
What is the difference between informatics 7x and 8x and what is latest version?
How do you promote a non-reusable transformation to reusable transformation?
Mention some types of transformation?
Explain the pipeline partition with real time example?
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
how many types of dimensions are available in informatica?
How does the aggregator transformation handle null values?
How to update or delete the rows in a target, which do not have key fields?
expain about the tune parameters?
Mention few power centre client applications with their basic purpose?