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 join two flat file if they have diff. structure?how to join one relational and one flat file?
Explain the tuning lookup transformation - informatica
how DTM buffer size and buffer block size are related
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve
What is the filename which you need to configure in UNIX while installing infromatica?
Design a mapping to get year of join for each employee.
what are the perameter and variable?
What is the use of an aggregator cache file?
How will you update the row without using update statergy?
what is bitmap index? did u use it?and how to use it in informatica
Which is the t/r that builts only single cache memory?