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
- 12117 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
Enlist the tasks for which source qualifier transformation is used.
How to improve the performance of a session using sorter transformation?
What are connected or unconnected transformations?
What are multi-group transformations?
What is rank index in rank transformation?
What is a passive transformation?
what is the size of your data warehousing?
Differentiate between source qualifier and filter transformation?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Difference between Target-based loading and constraint-based loading?
How can we use mapping variables in informatica? Where do we use them?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Partition, what happens if the specified key range is shorter and longer
Performance tuning( what you did in performance tuning)
How we can create indexes after completing the loan process?
