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
- 12162 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
What do you mean by filter transformation?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
what is the hint? how to use it to reduce the query processing in program?
What is rank transform?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Explain the difference between a data warehouse and a data mart?
what is degenerated dimension?
Explain the aggregator transformation?
update strategy transformation in informatica
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is the difference between STOP and ABORT options in Workflow Monitor?
How can we use mapping variables in informatica? Where do we use them?
What are the informatica performance improvement tips
