In Which scenario did u used Incremental loading?
Answers were Sorted based on User's Feedback
Whenever your record changes and any date column get
updated in source.This happens in mainly transactions where
amount or balance changes.This record is flagged based on
the the date colum which isnow changed and value become
greated then session run time when it was executed
previously.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ramu
for capturing the changed data in source we use the
incremental loading.
| Is This Answer Correct ? | 0 Yes | 0 No |
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y
What is the default source option for update stratgey transformation?
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
what is inline view?
What is tracing level and what are the types of tracing level?
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
Which transformation should u need while using the cobol sources as source defintions?
Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!