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.
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 |
Clarify the utilization of aggregator cache record?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
have you developed documents in your project? and what documents we develop in realtime?
how to run 2 workflows sequentially. plz respond what is the process?
what is unique constraint error ?
what is polling?
why we use materialized view over view?
Can we get 1st record through Informatica(without sequence number).
What is domain and gateway node?