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 |
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
How/where can i install Informatica software with oracle or teradata as database
Explain scd type 3 through mapping.
In which circumstances that informatica server creates Reject files?
Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!
what is the logic will you implement to load data into a fact table from n dimension tables?
what is upstream and downstream transformation?
Differentiate between mapping parameter and mapping variable?
How to identify this row for insert and this row for update in dynamic lookup cache
how to connect two or more table with single source qualifier?
I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions