How can we eliminate duplicate rows from flatfile,explain?

Answer Posted / nagaraj.g

using sorter transformation for distinct in a flat files

Is This Answer Correct ?    16 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by target load plan?

646


What is lookup transformation?

704


What is substr in informatica?

790


if we have a delimiters at unwanted places in a flat file how can we over come those.

1649


Explain transaction control transformation in informatica

909






IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

673


Design a mapping to load the cumulative sum of salaries of employees into target table?

1027


Different circumstance which drives informatica server to expel records?

635


How do you set a varible in incremental aggregation

1537


What are multi-group transformations?

649


Enterprise data warehouse your projects phase by phase explain?

1562


What is an aggregator transformation?

721


What are the types of caches in lookup?

667


Performance tuning( what you did in performance tuning)

1594


design of staging area?

1695