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
keys.
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
bsinivas1213@gmail.com
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
@nagaraju
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
ID.
Is This Answer Correct ? | 1 Yes | 3 No |
Can any one describe what is audit table briefly?how does it look like and what are the columns in it?
How to go to the older version for a mapping?
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
What is enterprise data warehousing?
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
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?
Explain lookup transformation in informatica
if i am having 10 records in source, i want 20 records in target...how will you do it
what is the difference between Informatica 7.1 and Abinitio?
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
Which is better performance wise database or file?How?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar