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 / rajesh aitha
Hello all,
We can use one Seq by creating reusable transformation in one repository folder and make the repository folder as shared folder.
But one constraint is there the in the question is all about to maintain the uniq key, being a challenge.
I have a suggestion to append a string for each record that is to maintain as S.key in the mapping it self.
like wf -1 will insert 1234A and wf -2 will insert 1235B as uniq key.
I suggest to know the exact functionality of Seq ...:-)
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What all are steps in up gradation of Informatica server?
Differentiate between a repository server and a powerhouse?
what is the hint? how to use it to reduce the query processing in program?
How to join three sources using joiner? Explain though mapping flow.
pmscmd startworkflow -sv
How can informatica be used for an organization?
What is the difference between a connected look up and unconnected lookup?
How to create a non-reusable instance of reusable transformations?
How to convert multiple rows to single row (multiple columns) in informatica
What are the features of complex mapping?
What are session parameters ? How do you set them?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
Explain lookup transformation is active in informatica
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
wf dont have integration severances how you can run?