Interested to Buy Any Domain ? << Click Here >> for more details...
What is meta data and system catalog?
- 2 Answers
- 8315 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 |
can we override a native sql query within informatica? Where do we do it?
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
enterprise datawarehouse your project phase by phase explain?
SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?
What is a filter transformation and why it is an active one?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?
How can we store previous session logs?
Three date formats are there . How to change these three into One format without using expression transformation ?
Have you worked with/created Parameter file
Repository user profiles
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Teradata 
