can v update d records in target using update stargey
without generationg primary key ? explain
Answers were Sorted based on User's Feedback
Answer / bsgsr
no using update strategy without primary keys update is not
possible. try and read teh session log file once. it will
display a msg updates are not supported without primary
update override in the target is to update the function in
the update strategy t/tion and it updates only on non-
primary key columns like dname, loc but not on deptno.
gilbert can i have your mail id here is mine
else call me on my num 9866188658 once v can have kt which
is mutually beneficial
|Is This Answer Correct ?||22 Yes||1 No|
Answer / nagaraju bhatraju
Other than this option like "Target update Override "
you can drag that target Warehouse desiner ,and mark those
columns which are no keys as a key for time being ,on whihc
you are trying to update. even though those columns are
not keys attributes or key columns at database level,for
time being those will be treated as key elements, hense you
can apply or use update strategy .
else generally informatica will through error like
" No key specification error"
|Is This Answer Correct ?||7 Yes||0 No|
Answer / sreekanth
above answer is perfect.
we can mark as PK in etl level even though field is not
a PK in DB level
|Is This Answer Correct ?||0 Yes||0 No|
Answer / leo gilbert
By using "Update override" option in the target. Say the
key of your table is ID,NAME. But your mapping is passing
only ID to the target then you can have an update override
query in the target to update the target only based on
|Is This Answer Correct ?||1 Yes||3 No|
What is the need of building a data warehouse?
i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?
i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...
where to select code page option?
What are the data movement modes in informatcia?
In development project what is the process to follow for an etl developer from day1
What is joiner transformation in informatica?
Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u
can we override a native sql query within informatica? Where do we do it? How do we do it?
what is scd?
can we use mapplet as starting n ending object in mapping