Interested to Buy Any Domain ? << Click Here >> for more details...
one source to target loading insert new rows and update
existing rows?
- 3 Answers
- 7200 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / s
We can achieve this
SRC->EXP->UPD->TGT.
In Update Transformation put DD_UPDATE. And in target add
update_override to update the required columns based on the
condition. At session level set the target load attribute
as INSERT, UPDATE ELSE INSERT.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Briefly explain the aggregator transformation?
explan ur project architecture?
how to load dimension table and fact table. plz tell me the steps.
What are the settings that you use to configure the joiner transformation?
What is resilience time?
What is olap (on-line analytical processing?
What are the different options available for update strategy?
How to generate or load values in to the target table based on a column value using informatica etl tool.
whats the logic to load the lower level of granularity of data to fact table.
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What the difference is between a database, a data warehouse and a data mart?
scenario where i can use only concurrent execution of workflow.
How many transformations can be used in mapplets.
What if the source is a flat-file?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
