Answer Posted / srinidhi koushik
Meta data is data about data. Power Center 6x / 7x creates
155 / 183 tables, when informatica is installed on an
environment. These tables contains all information of
transaction / changes done in Informatica.
Eg: we can find all the mappings / transformations - last
modified time / last successful run time etc. These tables
will usually have the naming convention OPB_.....
These objects / tables are created under schema pointing to
the database connection hich is provided when Power center
is installed
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is xml source qualifier transformation in informatica?
How many ways are there to create ports?
How do you load only null records into target? Explain through mapping flow.
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What's the layout of parameter file (what does a parameter file contain?)?
Can informatica load heterogeneous targets from heterogeneous sources?
How do you load first and last records into target table?
How do you update the records with or without using update strategy?
What is dynamic cache?
What is lookup change?
If informatica has its scheduler why using third party scheduler?
What is an expression transformation in informatica?
How to generate sequence numbers using expression transformation?