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 are the types of schemas we have in data warehouse and what are the difference between them?
How to load last n records of file into target table - informatica
Differences between version 7.x and 8.x.
What do you mean by enterprise data warehousing?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How to start a workflow using pmcmd command?
What do you mean by channel change?
Repository user profiles
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How do you change a non-reusable transformation to reusable transformation?
How to generate sequence numbers using expression transformation?
Explain how to import oracle sequence into informatica?
How do you manage the Parameter files while migrating your data from one environment to another environment?
To import the flat file definition into the designer where should the flat file be placed?
Explain the different dimensions.