How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?

Answer Posted / chandu

we can achieve this by using first value or last value in lkp properties.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to delete duplicate row using informatica?

697


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

641


How do you use reject loader.

2186


What is a predefined event?

750


What is the advantage of informatica?

738






What is incremental aggregation?

671


Explain the difference between a data warehouse and a data mart?

678


Under which circumstances, informatica server creates reject files?

685


How to call shell scripts from informatica?

662


What do you understand by a term domain?

768


Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1504


What are the popular informatica products?

720


What you know about transaction control transformation?

645


What are roles and groups and benefits of using them?

656


How do we call shell scripts from informatica?

665