What is the difference between SOURCE and TARGET BASED
COMMITS?
Answers were Sorted based on User's Feedback
Answer / swathi
Requesting you guys, if you know the answer post it. Plz
dont post senseless things here..
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / suresh
source based means not depending upon how many records
written to target,the Integration service commit data.
target commit means not depending upon how many records read
from source it will commit.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / buddy
source means reading from source and target means loading into
target
| Is This Answer Correct ? | 0 Yes | 2 No |
sample mappings for scd1,scd2 and scd3
what is Active lock explain
how the informatica server sorts the strings values in rank transformations?
What is the difference between router and filter?
What is workflow? What are the components of workflow manager?
Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
Major difference between SQL override and Lookup Sql override
Can we run session without using workflows?
If I am having 6 flat files in data. How can you load the data at a time
what is incremental aggregation ,with example?
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
Is it possible to update the target table with PK?