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
- 11951 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
How do you use reject loader.
How to start a workflow using pmcmd command?
What is the use of target designer?
whats the logic to load the lower level of granularity of data to fact table.
difference between repository database and repository service?
How does a rank transform differ from aggregator transform functions max and min?
What are the different types of olap? Give an example?
What do you understand by a term domain?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What does role playing dimension mean?
Explain incremental aggregation in informatica
Differentiate between a database and data warehouse?
What is status code in informatica?
What is Index Caches size?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
