How to update records in Target, without using Update Strategy?
Answer Posted / brahma
the table does not have keys u can write sql query at target
level. in target table properties there is a option update
override.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Write the prerequisite tasks to achieve the session partition?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What are the various types of transformation?
What is the reusable transformation?
What is the cumulative sum and moving sum?
What is pmcmd command?
How to improve the performance of a session using sorter transformation?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How can we delete duplicate rows from flat files?
What do mean by local and global repository?
How do you set a varible in incremental aggregation
What is the way to execute pl/sql script using informatica mapping?
What are the different types of repositories created using informatica?
What is meant by active and passive transformation?