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 the source table into flat file target(with columns) in informatica?
what is shared Cache. when we will use shared Cache?
how can we use sorter transformation in joins?
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
How to improve the performance of a session using sorter transformation?
Can we override a native sql query within informatica?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Explain pmcmd command usage in informatica
how do u move the code from development to production?
Differentiate between source qualifier and filter transformation?
source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks
how we do performence tuning in informatica