Interested to Buy Any Domain ? << Click Here >> for more details...
explain abt joiner t/r?
- 1 Answers
- 4090 Views
- IBM, I also Faced
- E-Mail Answers
Joiner transformation is used to join source data from two
related heterogeneous sources. However this can also be used
to join data from the same source. Joiner t/r join sources
with at least one matching column. It uses a condition that
matches one or more pair of columns between the 2 sources.
To configure a Joiner t/r various settings that we do
are as below:
1)Master and detail source
2)Type of join
3)Condition of the join
| Is This Answer Correct ? | 5 Yes | 0 No |
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 do mean by local and global repository?
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
what is the difference between Informatica7.1 & informatica 8.1
What is the function of look up transformation?
Explain lookup transformation source types in informatica
Difference between task flow and linear task flow
What is the need of building a data warehouse?
Have you worked with/created Parameter file
what is meant by lookup caches?
2 Answers Cap Gemini, Informatica,
in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify
Teradata 
