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

What are the types of presistent cache in look up tr.

0 Answers   IBM,


how to return multiple columes through through un-connect lookup?

1 Answers   DELL,


Can u generate reports in Informatica?

0 Answers   Informatica,


Where is the cache stored in informatica?

5 Answers   Infosys, Satyam,


What are the designer tools for creating transformations?

0 Answers   Informatica,






how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

0 Answers  


What is checksum termnology in informatica? Where do you use it ?

3 Answers   Chase, Cognizant, Deloitte,


source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

6 Answers   CTS, Wipro,


What is domain and gateway node?

0 Answers  


What are variable ports and list two situations when they can be used?

1 Answers  


what are the Methods For Creating Reusable Transformations?

0 Answers   Informatica,


Why we select the table which has minimum number of records as Master table in joiner?

4 Answers   HG, UST,


Categories