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 |
How to load duplicate records in to a target table which has a primary key?
Define enterprise data warehousing?
What are the disadvantages of Sequence Generator T/R?
if we r using aggregator we enabled sorted input but the records r not sorted what happen?
Which kind of index is preferred in DWH?
I have a flat file, want to reverse the contents of the flat file
What is expression transformation?
Why is meant by direct and indirect loading options in sessions?
Define joiner transformation?
Explain reference cursor?
What is workflow? What are the components of the workflow manager?
What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1