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 |
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How union transformation is active ?
What is deployemnt groups, Lables, query and dynamic deployment group.
How many ways you create ports?
in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 Answers HCL, Thomson Reuters,
how can one eliminate dupliacte data with out using distinct option?
i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z
When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
How to load only the first and last record of a flat file into the target?
how to get the first row without using rank t/r?