surrogate keys usage in Oracle and Informatica?
Answer Posted / palani
Its mainly used to maitain the uniqueness in the target
system that contains records from various source systems
ie. different source system may contain different keys as a
primary key.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What does update strategy mean, and what are the different option of it?
which one is better performance wise joiner or look up
How can we use mapping variables in informatica?
In informatics server which files are created during the session rums?
r u done any partitions in ur project?
How to extract sap data using informatica?
what is song in infrmatica...?
What is the difference between source qualifier transformations source filter to filter transformation?
What is a joiner transformation and why it is an active one?
Explain lookup transformation in informatica
what is the Default Source Option For Update Strategy Transformation?
What is difference between a gateway node and worker node?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Briefly explain the aggregator transformation?
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.