Answer Posted / mike
A synonym is a alternative name for objects such as tables,
views, sequences , stored procedures and other database
objects.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How many ways a relational source definition can be updated and what are they?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is deployment group?
What is joiner transformation?
Differences between version 7.x and 8.x.
Explain the different kinds of facts.
How to extract sap data using informatica?
What is a difference between complete, stop and abort?
expain about the tune parameters?
What are the limitations of joiner transformation?
What are the different ways to implement parallel processing in informatica?
What are the measure objects?
Where is metadata stored?