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 |
whatis the default data driven operation in informatica
How to compare Source and Target table, without using dynamic lookup?
What is dynamic cache?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What are the limitations of joiner transformation?
What is an expression transformation in informatica?
Which kind of index is preferred in DWH?
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
what is upstream and downstream transformation?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Where do we use mapping variables in informatica?