What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
1 1157Suppose 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?
853Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
830Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
892Post New Informatica Questions
Define the various join types of joiner transformation?
How to extract sap data using informatica? What is abap? What are idocs?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Can you generate sequence numbers without using the sequence generator transformation?
How do you change a non-reusable transformation to reusable transformation?
What is the need of etl tools?
Enlist the advantages of informatica.
What are the restrictions of union transformation?
How can we delete duplicate rows from flat files?
what is diff b/t sorter t/r and agg have the option sorter property...
What is the difference between STOP and ABORT options in Workflow Monitor?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How to generate sequence numbers without using the sequence generator transformation?
