what is surrogatekey ? In ur project in which situation u
has used ? explain with example ?
Answer Posted / soujanya
surrogate key is the system generated key to avoid primary
key conatraint.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between STOP and ABORT options in Workflow Monitor?
How do you load unique records into one target table and duplicate records into a different target table?
What is an Integration service in Informatica?
How can we use mapping variables in informatica?
How to open an older version of an object in the workspace?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is the scenario which compels informatica server to reject files?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How to elaborate tracing level?
Briefly explain the aggregator transformation?
what is the size of your data warehousing?
What is persistent lookup cache?
What is the need for an etl tool?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?