What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
1 1560Suppose 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?
1100Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
1092Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
1135Post New Informatica Questions
How to create the source and target database connections in server manager?
what is the complex transformation you used in informatica
In development project what is the process to follow for an etl developer from day1
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What do you understand by SOA of Informatica?
What can we do to improve the performance of informatica aggregator transformation?
What are the various types of transformation?
Plz can any one say me how to get the informatica certification materials and dumps
What is confirmed fact in dataware housing?
Define the various join types of joiner transformation?
What is the command used to run a batch?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Explian the Process of deployment groups in informatica
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Differentiate between source qualifier and filter transformation?