Interested to Buy Any Domain ? << Click Here >> for more details...
can v update d records in target using update stargey
without generationg primary key ? explain
- 4 Answers
- 16900 Views
- CTS, I also Faced
- E-Mail Answers
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 |
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
what is confirmed dimension?
What is the Difference between DSS & OLTP?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
Partition, what happens if the specified key range is shorter and longer
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc
following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000
What is an expression transformation in informatica?
What is the use of incremental aggregation?
I want skip first 5 rows to load in to target? what will be the logic at session level ??
Teradata 
