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
How to configure mapping in informatica?
Is there any target staging area in informatica not staging area
Where is metadata stored?
What do you understand by a term domain?
Why do you use Mapping Parameter and mapping variable?
How does a sorter cache works?
What is the use of transformation?
how to load rows into fact table in data warehouse
What is target load order?
What is rank transformation?
How to do unit testing in informatica? How to load data in informatica ?
How to open an older version of an object in the workspace?
what is the complex transformation you used in informatica
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?
Explain sessions. Explain how batches are used to combine executions?