Answer Posted / krish
it is active transformation, we can use this for applying multiple conditions on data and we can load into multiple targets
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are mapplets?
What will be the approach?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Have you worked with/created Parameter file
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
design of staging area?
Explain pushdown optimization and types in informatica
What are the settings that you use to configure the joiner transformation?
What is the benefit of partitioning a session?
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 are batches?
whats the logic to load the lower level of granularity of data to fact table.
What is the need of an ETL tool?
What is pmcmd command?