Answer Posted / swetha
The PowerCenter repository allows you to share metadata
across repositories to create a data mart domain. In a data
mart domain, you can create a single global repository to
store metadata used across an enterprise, and a number of
local repositories to share the global metadata as needed.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is a sequence generator transformation?
What is the use of an aggregator cache file?
Design a mapping to load a target table with the following values from the above source?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Where can we find the throughput option in informatica?
In informatics server which files are created during the session rums?
can anyone suggest best free Talend data integration training online
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Why is sorter an active transformation?
Is it possible to create multiple domains on a single Informatica server?
What are the static cache and dynamic cache in informatica?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?