If we have 1000 rows were loaded in to datawarehouse and
next day the source have 1010 rows so, how can we loaded
only updated rows into target.
Answer Posted / gazulas
sql override the sq, using a parameter_value.
select * from xxx where date = parameter_value.
pass the value form par file and run it. only particular date records will be extracted....;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is rank transform?
What is flashback table ? Advance thanks
What do you mean by channel change?
How do you update the records with or without using update strategy?
How are the sources and targets definitions imported in informatica designer?
What is a predefined event?
Briefly define a session task?
What are active and passive transformations?
What do you mean by enterprise data warehousing?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What is the benefit of session partitioning?
permutations of mapplet
Explain the mapping variable usage example in informatica
Can informatica load heterogeneous targets from heterogeneous sources?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?