What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
1 870Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
656Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
628Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
632Post New Informatica Questions
draw informatica architecture 8.6 ?
Why union transformation is an active transformation?
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 the Process to creating lookup transformation in informatica
Explain incremental aggregation in informatica
Where are the source flat files kept before running the session?
What do you mean by filter transformation?
Do you find any difficulty while working with flat files as source and target?
What is rank index in rank transformation?
Differences between connected and unconnected lookup?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is the fact table?
Clarify the utilization of aggregator cache record?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Quickly characterize reusable change?
