What is meta data and system catalog?
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 |
Why union transformation is an active transformation?
Any one can tell me how to explain puss-down optimization ? explain me with example plz?
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
What are the ETL tools available in DWH?
What does refresh system mean, and what are its distinctive choice?
What is confirmed fact in dataware housing?
I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE
wht is cdc?how to use it in creation of mappings?
supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How
how can u load the data in time dimension?
how can you load data into target table without leading zeor's
What is the difference between a connected look up and unconnected lookup?