Interested to Buy Any Domain ? << Click Here >> for more details...
wht is full process of Information source to target
just like stg to productuon and development
- 1 Answers
- 7153 Views
- Informatica, I also Faced
- E-Mail Answers
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
How do you manage the Parameter files while migrating your data from one environment to another environment?
Repository user profiles
What is data transformation manager process?
explan ur project architecture?
How do you load only null records into target?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What will be the approach?
Explain in detail about scd type 1 through mapping.
How to do the error handling of if ur source is flatfiles?
Explain about Informatica server process that how it works relates to mapping variables?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Write the program through which the records can be updated?
What does update strategy mean, and what are the different option of it?
Write the unconnected lookup syntax?
How to differentiate between the active and passive transformations?
