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
How do you migrate data from one environment to another?
what is the -ve test case in your project.
Differences between connected and unconnected lookup?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What happens when a session fails and you click on recover?
What all join we can perform in LOOKUP transformation?
4 yrs etl devloper roles and responsibilities?any body give solutions
What are the different clients of powercenter?
What do think which one is the better joiner or look up?
What are the different types of repositories created using informatica?
How can you validate all mappings in the repository simultaneously?
Different circumstance which drives informatica server to expel records?
What is event and what are the tasks related to it?