Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

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.

Question Posted / jatin marwaha

Answer Posted / jatin marwaha

Use Dynamic Lookup on 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

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

1958

Performance tuning( what you did in performance tuning)

1979

Enlist the differences between database and data warehouse.

1115

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1275

Why union transformation is an active transformation?

1045

update strategy transformation in informatica

1064

What is the difference between STOP and ABORT options in Workflow Monitor?

1257

What are the data movement modes in informatica?

1150

can u give example for factless fact table

6641

How do you migrate data from one environment to another?

1095

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

1988

What is a standalone command task?

1203

What is the difference between source qualifier transformations source filter to filter transformation?

1044

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2858

what is unit testing?tell me proceedure

2220