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
- 17010 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
can any one give some examples for pre sql and post sql(Except dropping and creating index).
whats the logic to load the lower level of granularity of data to fact table.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
r u done any partitions in ur project?
How might one distinguish in the case of mapping is right or not without associating session?
explain one complex mapping with logic? sales project?
can u any challenge your project?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
without table how to come first record only in oracle?
Can we create a Integration service without a Repository service and vice versa?
Could you explain what is enterprise data warehouse?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
which one is better performance wise joiner or look up
What is the function of aggregator transformation?
What are the differences between source qualifier and joiner transformation?
