How do you avoid duplicate records with out using source
qualifier,expression,aggrigator,sorter and lookup
transformations ?

Answer Posted / manojkumar

Thank you prasad.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain incremental aggregation in informatica

640


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

622


what is the size of your data warehousing?

1657


Clarify the aggregator change?

582


What are the tuning techniques you applied during your last project

1549






Can anyone tell me the new features in Informatica 9 Version?

1516


Partition, what happens if the specified key range is shorter and longer

2019


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??

546


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

5544


Explain lookup transformation source types in informatica

684


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1718


What is enterprise data warehousing?

599


What is the cumulative sum and moving sum?

739


What are the steps involved in the migration from older version to newer version of Informatica Server?

1566


Explain the types of lookup transformation?

549