What are the basic needs to join two sources in a source
qualifier?
Answer Posted / swetha
Two sources should have primary and Foreign key relation ships.
Two sources should have matching data types.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to open an older version of an object in the workspace?
How are indexes created after completing the load process?
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 is session task and command task?
Where is metadata stored?
What is the meaning of decode in informatica?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Explain how many types of dimensions are available in informatica?
How to delete duplicate row using informatica?
Why is sorter an active transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
How do you load first and last records into target table?
What is joiner transformation?