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
- 12173 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / priyank
At mapping level,
SRC --> EXP --> FIL --> TGT
--> LKP_TGT
where
LKP_TGT: The look up on the target tables key columns
EXP:
OUT_UPD --> IIF(LKP_TGT.COL is NOT NULL AND ((LKP_TGT.COL1
<> SRC.COL1) OR (LKP_TGT.COL2 <> SRC.COL2)....,'UPD','INS')
FIL: OUT_UPD --> OUT_UPD='UPD'
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the prerequisite tasks to achieve the session partition?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Enterprise data warehouse your projects phase by phase explain?
How an expression transformation differs from aggregator transformation?
What is confirmed fact in dataware housing?
How to delete duplicate row using informatica?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Enlist the advantages of informatica.
Explain constraint based loading in informatica
What is a dimensional model?
What is powercenter on grid?
What is aggregator transformation in informatica?
What are the different types of repositories created using informatica?
How can we use mapping variables in informatica?
What do you understand by a term domain?
