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 |
why we need informatica
i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...
i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?
what is the difference between Informatica 7.1 and Abinitio?
why we use informatica in our project?
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how
Differentiate between Load Manager and DTM?
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task
Explain Dataware house architecture .how data flow from intial to end?
How union transformation is used?
Without using any transformations how u can load the data into target?
difference between repository database and repository service?