Answer Posted / shiva
surrogate key is a artificial key or system generated
key.when ever a primary key violation occurs,by using
sequence generator t/m we generate surrogate keys
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What will be the approach?
What is decode in static cache?
What is a filter transformation?
what is the complex transformation you used in informatica
Explain lookup transformation is active in informatica
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Different sorts of metadata that stores in the storage facility?
write a query to retrieve the latest records from the table sorted by version(scd)
draw informatica architecture 8.6 ?
Explain the types of transformations?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Which is the t/r that builts only single cache memory?
What is confirmed fact in dataware housing?
Informatica settings are available in which file?
Partition, what happens if the specified key range is shorter and longer