What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
1 1478Suppose 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?
1040Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
1043Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
1099Post New Informatica Questions
Did u used latest transformations of 8.6.0? for what?
How to call shell scripts from informatica?
What are roles and groups and benefits of using them?
What is difference between a gateway node and worker node?
What is sorter transformation?
What does “tail –f” command do and what is its use as an Informatica admin.
What is the need of etl tools?
What are the different ways to implement parallel processing in informatica?
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?
How do we call shell scripts from informatica?
How to load the data from people soft hrm to people soft erm using informatica?
Define mapping and session?
How we can create indexes after completing the loan process?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?