My source contains 10 records with 5 columns.What happens if I
select group by all columns in Aggregator T/R?
Answers were Sorted based on User's Feedback
Answer / abhinaw prakash
If u group by all the columns it will group the Data
sequentially according to the Port order and send it to the
Next transformation.
Is This Answer Correct ? | 1 Yes | 0 No |
Can you copy the session to a different folder or repository?
Using Connected or unconnected lookup for performance wise which one is preferable?.
What is Index Caches size?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is a passive transformation?
I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
What are mapping parametres and variables in informatica?
What are the basic needs to join two sources in a source qualifier?
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
What is a candidate key?
who to split dimentions into sub dimention
How to load a Dimension ? and how to load a fact table?