1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

How to load the data into target table, which not have
Primary/Surrogate key (Duplicate records not acceptable)

Question Posted / santosh kumar sarangi

Answer Posted / santosh kumar sarangi

1. If source is relational then in SQ you can check the
distinct or in mapping we can use distinct in sorter t/r.
2.if flat file then distinct in sorter t/r.

It will not allow nay duplicate data, so target will get
only distinct data.

Let me know if any thing wrong.

Thanks & regards
Santosh Kumar Sarangi

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1042

Explain the aggregator transformation?

625

What does cheating measurement mean?

593

define galaxy repository in informatica

1721

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

5777




Can we create two repositories on same database instance in oracle?

605

How to update source definition?

627

What is informatica metadata and where is it stored?

581

What is the function of aggregator transformation?

573

How do you update the records with or without using update strategy?

660

What will be the approach?

577

How can you differentiate between powercenter and power map?

621

What is a predefined event?

656

How to load last n records of file into target table - informatica

596

What is session task and command task?

645