Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 15385 Views
- Barclays, I also Faced
- E-Mail Answers
Answer Posted / suneel reddy
Create triggers in the DataBase on Inserts, use Oracle sequence to generate/fill the surrogate key
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the need of etl tools?
how to create user defined function (udf) in informatica
What do you understand by term role-playing dimension?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
To import the flat file definition into the designer where should the flat file be placed?
Under what condition selecting sorted input in aggregator may fail the session?
Explain scd type 3 through mapping.
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Different qualification between a related rotate toward the sky and isolates look upward?
What is a grid in Informatica?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Enlist few areas or real-time situations where informatica is required.
