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
- 12186 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 |
How do you manage the Parameter files while migrating your data from one environment to another environment?
Can we insert ,update ,delete in target tables with one update strategy tran.?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in
Define Pmrep command?
Why we use ENABLE HIGH PRECISION in session properties?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How can you differentiate between powercenter and power map?
Explain the informatica workflow?
tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
What will be the approach?
Suppose we do not group by on any ports of the aggregator what will be the output?
Teradata 
