when we dont use aggregator in mapping ?
Answers were Sorted based on User's Feedback
Aggregator transformation is used to calculate values in a
group. It is the only t/r which can be used for aggregate
calculations e.g: Sum,avg,max,min,count....
So when we don't need any such aggregate calculations, than
we don't use aggregator transformation.
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / vikram
when thre are no group by or any other calculations required
| Is This Answer Correct ? | 9 Yes | 1 No |
Explain what are the different types of transformation available in informatica.
How you can differentiate between connected lookup and unconnected lookup?
what is filelist concept in informatica
What is sequence generator transformation in informatica?
Explain sql transformation in script mode examples in informatica
I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)
3 Answers Alcatel-Lucent, ECI Telecom,
I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?
What is a passive transformation?
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
how we load the data from source to staging area
how to create a sample mapping for dynamic lookup transformation
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...