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
- 11234 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / babu
By selecting 'UPDATE else insert' in the 'Treat source rows
as :'from
session properties we can get updated rows and new rows..
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / chinni
hi this is bhargav
u can use "control table logic" to do so
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / gazulas
sql override the sq, using a parameter_value.
select * from xxx where date = parameter_value.
pass the value form par file and run it. only particular date records will be extracted....;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / aswinigallery@gmail.com
Yes, we can use scd type 1 (only update flow).
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mahipal reddy
By selecting 'UPDATE' in the 'Treat source data as:'from
session properties we can get only updated rows..
| Is This Answer Correct ? | 4 Yes | 7 No |
why we need informatica
What is an aggregator transformation?
What are the performance considerations when working with aggregator transformation?
when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?
version controlling in informatica?
Could you explain what is enterprise data warehouse?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
why we use informatica in our project?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is different between informatica version 8 and 9 version
How to send duplicates to one target and unique rows to one target?target is empty
what happens when a batch fails?
Teradata 
