without dynamic lookup transformation how to insert new
rows and update existing rows?
Answer Posted / vali
you can use source qualifier transformation to do this.
write join condition ...
the rest of the operation will be same
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
tell me about your project functionality
What are the different types of repositories created using informatica?
What is the difference between router and filter?
What all join we can perform in LOOKUP transformation?
Why sorter is an active transformation?
Enlist the tasks for which source qualifier transformation is used.
Can you use flat files in Mapplets.
generate date / time dimension in informatica
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How can we delete duplicate rows from flat files?
How to elaborate powercenter integration service?
Write the different tools in the workflow manager?
What could be the possible resons of locks by user?
What is deployment group?
How can repository reports be accessed without sql or other transformations?