Aggregator transformation is having fields say a,b,c,d,e group
by is enabled on a,b,c with sorted input,How the aggregator
transformation process the i/p data?or in which way i/p comes
to agg transformation
Answer / priyank
Aggregator transformation will pass the output as the last
row coming in for the group a,b,c.
Is This Answer Correct ? | 0 Yes | 4 No |
What is difference between stored procedure transformation and external procedure transformation?
How to import oracle sequence into Informatica?
Explain transaction control transformation in informatica
what are the types of facts with Examples?
In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?
my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?
Can any body tell about the (UTC) unit test cases with the examples in informatica.
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?
How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?
Can any one describe what is audit table briefly?how does it look like and what are the columns in it?
Make a note of the quantity vaults made in informatica?