What is a surrogate key?Why we use it in a mapping?Pl give
an example.
- 4 Answers
- 10865 Views
- PCS, I also Faced
- E-Mail Answers
Answer Posted / venkadesh
IT IS UNIQUE KEY AND ITS USED FOR COMPARING THE EMPLOYEE DETAILS
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Explain direct and indirect flat file loading (source file type) - informatica
Does an informatica transformation support only aggregate expressions?
What is a filter transformation and why it is an active one?
What is transformation?
What do you mean by channel change?
While migrating the data from one environment to another environment how would you manage the connections?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is olap (on-line analytical processing?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Which is the t/r that builts only single cache memory?
Write the program through which the records can be updated?
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 load the name of the current processing flat file along with the data into the target using informatica mapping?
Tell me about Propagate functions in informatica
