Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SOURCE and TARGET BASED
COMMITS?
- 3 Answers
- 6772 Views
- IBM, I also Faced
- E-Mail Answers
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 |
What is a data modeling?
What is aggregate awareness?
What are the informatica performance improvement tips
Is it possible to create multiple domains on a single Informatica server?
What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?
how many ways can we implement SCD2?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
What does “tail –f” command do and what is its use as an Informatica admin.
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
how will you remove the duplicate records from flat file without using sorter?
What are some examples of informatica etl programs?
Teradata 
