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 |
What is aggregate awareness?
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
What is decode in informatica?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?
can u any challenge your project?
What is Java Transformation? what are the uses of it?
What are the popular informatica products?
What is a configuration management?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Is there any way to read the ms excel datas directly into informatica?
In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?