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.
- 9 Answers
- 13253 Views
- Barclays, I also Faced
- E-Mail Answers
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
Explain lookup transformation in informatica
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is meant by a domain?
What are the different ways to implement parallel processing in informatica?
What is rank transformation?
What happens when a session fails and you click on recover?
Define update strategy?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Global and Local shortcuts. Advantages.
Explain the types of transformations?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
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?
What are the tuning techniques you applied during your last project
Explain about Informatica server process that how it works relates to mapping variables?
Did u used latest transformations of 8.6.0? for what?
