Interested to Buy Any Domain ? << Click Here >> for more details...
What is meta data and system catalog?
- 2 Answers
- 8177 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 |
what is target load plan
From where we can start or use pmcmd?
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
What aer the out put files that the informatica server creates during the session running?
tell me 7.x and 8.x diferrencess(but not transformations)
can you avoid static cache in the lookup transformation? I mean can you
What are two types of processes that informatica runs the session?
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
what is normalizer transformation?
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
Mapplets can you use an active transformation in a mapplet,
Teradata 
