Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 6 Answers
- 12333 Views
- Accenture, I also Faced
- E-Mail Answers
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
Is there any way to read the ms excel datas directly into informatica?
What is an active transformation?
How can you validate all mappings in the repository simultaneously?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What are the uses of etl tools?
What are the settings that you use to configure the joiner transformation?
What is Session and Batches?
can we override a native sql query within informatica? How do we do it?
How to join three sources using joiner?
what is unit testing?tell me proceedure
Write the unconnected lookup syntax and how to return more than one column.
What are the limitations of joiner transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
How to use procedural logic inside infromatica?
lookup transformation with screenshots
