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
- 11905 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
Separate from a database, an information bazaar, and an information stockroom?
How union transformation is used?
During the running session, output files are created by informatica server. Enlist few of them.
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is union transformation in informatica?
What is difference between a gateway node and worker node?
What are the measure objects?
What are the components of the workflow manager?
whats the logic to load the lower level of granularity of data to fact table.
What are the various types of transformation?
Explain transaction control transformation in informatica
What is workflow? What are the components of workflow manager?
How do you load first and last records into target table?
Explain what is informatica metadata and where is it stored?
How can we update a record in the target table without using update strategy?
