Answer Posted / aswin
use aggregator and do not apply any aggregation function, it will return only last row in the group..if you dont provide any groupby and aggregate value it will return only last row..so you can aviod dups
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the different versions of informatica?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Informatica Checkpoints
How can you validate all mappings in the repository simultaneously?
Explain the code page compatibility?
What is the function of aggregator transformation?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What are the conditions needed to improve the performance of informatica aggregator transformation?
Parameter and variable differences
What are the tasks that can be performed using sq?
Explain lookup transformation source types in informatica
Explain the etl program with few examples.
explain abt ur project architecture?
What is a surrogate key?
What is workflow manager?