What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
Answer / ysindhureddy77@gmail.com
If we do not use an input port in group-by neither in aggregate expression, the Integration Service
will return only the last row value of the column for the input rows.
For example, if we have 100 rows coming from source then aggregator will output only the last record (100th
record)
Is This Answer Correct ? | 0 Yes | 0 No |
Where is metadata stored?
What is blocking transformation?
If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
how may sources can be used in a mapping at a time?(limit)
can session assigned multiple mappings or not?
How to import oracle sequence into Informatica?
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
What are the different clients of powercenter?
what is correlated query?
Quickly characterize reusable change?
a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100
While importing the relational source defintion from database,what are the meta data of source U import?