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

what is surrogatekey ? In ur project in which situation u
has used ? explain with example ?

Question Posted / kalpana

Answer Posted / kalpana

Some times the primary constraint may violate at that time
we go for surrogate key.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the command used to run a batch?

1110

How to load the data from a flat file into the target where the source flat file name changes daily?

1098

What is the difference between informatics 7x and 8x and what is latest version?

1136

How do you convert single row from source into three rows into target?

1211

What is a sorter transformation?

1155

Can you use flat files in Mapplets.

2712

How to convert multiple rows to single row (multiple columns) in informatica

1425

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.

1798

Explain the scenario which compels informatica server to reject files?

1207

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

2009

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1954

What is an active transformation?

1159

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.

2900

What is workflow manager?

1099

Enlist the various types of transformations.

1119