What is meta data and system catalog?
- 2 Answers
- 8465 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mln
as of my knoledge metadata is data about data or structure
of the database objetcts like tables or indexs etc.
no idea about syscatlog
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
I have source like this 1:2;3. so i want to load the target as 123
how to get flatfile containg 10 records half records one target another half another target
how to work with mapplet designer in informatica?
how to run 2 workflows sequentially. plz respond what is the process?
What is difference between maplet and reusable transformation?
Differentiate between router and filter transformation?
What is informatica? Why do we need it?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
in realtime which situations u can use unconnected lookup transformation
What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?
If we have lookup table in workflow how do you trouble shhot to increase performance?
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
Teradata 
