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
- 12328 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 |
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
What is the term PIPELINE in informatica ?
Filter transformation in the condition one of the data is NULL would the record be dropped.
What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?
111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?
What is Java Transformation? what are the uses of it?
how to work with mapplet designer in informatica?
Explain reference cursor?
What is the need of an ETL tool?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
Teradata 
