Interested to Buy Any Domain ? << Click Here >> for more details...
What is meta data and system catalog?
- 2 Answers
- 8273 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 |
Explain the flow of data in Iinformatica?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What are Dimensional table?
how the informatica server sorts the strings values in rank transformations?
if i am having 10 records in source, i want 20 records in target...how will you do it
How the dimensions will be loaded?
How to load a relational source into file taget?
what is degenerated dimension
what is the diff b/w target load plan and cbl?
How do you load alternate records into different tables through mapping flow?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
How can we improve session performance in aggregator transformation?
Teradata 
