How to enter same record twice in the target table,explain?
Answer Posted / shankar
if there is primary key there then this cant be done. we get an error 'unique constraint violated'error. hence very less scope here. if we can assign any i.d then there might be some scenarios where we can do this.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the surrogate key?
What is the format of informatica objects in a repository?
What is a filter transformation and why it is an active one?
Define mapping and session?
How to call shell scripts from informatica?
Which files are created during the session rums by informatics server?
What are the different options available for update strategy?
What is DR strategy for Informatica project?
How can we update a record in the target table without using update strategy?
What is xml source qualifier transformation in informatica?
How to create the source and target database connections in server manager?
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?
What are the advantages of using informatica as an etl tool over teradata?
What is incremental aggregation?
Have you worked with/created Parameter file