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
- 12141 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
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?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Design time, run time. If you don't create parameter what will happen
What is a difference between complete, stop and abort?
What is sequence generator transformation in informatica?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What are the types of caches in lookup? Explain them.
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
How can a transformation be made reusable?
How is union transformation utilized?
difference between informatica 8.1.1 and 8.6
is it possible to index the data in cache of lkp transformation ?
What is a mapplet/worklet in informatica?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is aggregate cache in aggregator transformation?
