can v update d records in target using update stargey
without generationg primary key ? explain
- 4 Answers
- 15426 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
How to update source definition?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Which transformation is needed while using the Cobol sources as source definitions?
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
What is joiner transformation in informatica?
What is the function of aggregator transformation?
Is it possible to define a single node as a Gateway node as well as worker node?
1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance
what is SDLC way of code development?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
my source is junk data how will u remove that junk data by using unix please any one replay me
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
In informatics server which files are created during the session rums?
Target increases every day even though no new record was inserted
What is the use of source qualifier?
