wht is full process of Information source to target

just like stg to productuon and development



wht is full process of Information source to target just like stg to productuon and development..

Answer / 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

More Informatica Interview Questions

Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers   Informatica,


Can you start a session inside a batch individually?

2 Answers  


Could any one to tell How to use the Oracle Analytic functions in Informatica?

1 Answers  


Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks

2 Answers   IBM,


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

0 Answers  






Which transformation should we use to normalize the COBOL and relational sources?

4 Answers   DELL, IBM, Lehman Brothers,


What are active transformations.

0 Answers  


Performance tuning in UNIX for informatica mappings?

0 Answers   CGI, CTC,


Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

4 Answers   IBM, Infotech,


If informatica has its scheduler why using third party scheduler?

0 Answers  


How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

3 Answers   CTS, HCL, Infosys, TCS,


why u go for dimensions ?

3 Answers   TCS,


Categories