How can i maintain unique surrogate key if 2 seperate
workflows from different repository run and insert/update the
main table at the same time.

Answer Posted / nithya

By having a dynamic lookup at the target table

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the types of transformations?

592


How do you promote a non-reusable transformation to reusable transformation?

658


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

548


How many input parameters can exist in an unconnected lookup?

984


Differentiate between a database and data warehouse?

650






What is meant by incremental aggregation?

578


explain one complex mapping with logic? sales project?

6140


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1493


What is Index Caches size?

612


What are the tasks that can be performed using sq?

608


Explain what is informatica metadata and where is it stored?

602


Explain incremental aggregation in informatica

650


What is meant by a domain?

623


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1576


what is the complex transformation you used in informatica

2185