One of the optimizing technique to improve the session
performance is push down optimization,by using push down
optimization we push as much as transformation logic to
source/target database,but this degrades the d/b
performance,how to overcome this?
Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.
What is the difference between STOP and ABORT options in Workflow Monitor?
can we use union transformation in joiner transformation?how?
1 Answers Dabur, Tech Mahindra,
What are differences between Informatica 7.1 and 6.1
How can you validate all mappings in the repository simultaneously?
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is option by which we can run all the sessions in a batch simultaneously?
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 do Integration testing in Informatica?
How many numbers of sessions can one group in batches?
How the dimensions will be loaded?