Answer Posted / pawan
Test Load is an option at session level.Enabling this option provides an option for debugging & dry run of informatica codes without any (impacts) commit in target tables. Number of rows for dry run/testing can also be specified .By default its 1.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain the tuning lookup transformation - informatica
What is source qualifier transformation in informatica?
Define enterprise data warehousing?
Briefly define a session task?
How to do the error handling of if ur source is flatfiles?
Why update strategy and union transformations are active?
whats the logic to load the lower level of granularity of data to fact table.
How can informatica be used for an organization?
What are the different types of transformation available in informatica.
What do you mean incremental aggregation?
what is the complex transformation you used in informatica
Where do we use mapping variables in informatica?
What is a grid in Informatica?
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
How to create or import flat file definition in to the warehouse designer?