Interested to Buy Any Domain ? << Click Here >> for more details...
Is it possible to update the target table with PK?
- 1 Answers
- 6518 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / vikram
You needs to use PK for updating the Target table along
with the Update Strategy and select Datadriven @ session
level.
| Is This Answer Correct ? | 20 Yes | 2 No |
Post New Answer View All Answers
What are the types of caches in lookup? Explain them.
What is the commit type if you have a transaction control transformation in the mapping?
How to do the error handling of if ur source is flatfiles?
What do you understand by SOA of Informatica?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is the Process to creating lookup transformation in informatica
Explain transaction control transformation in informatica
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is informatica etl tool?
Explain the difference between mapping parameter and mapping variable?
What is a predefined event?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Briefly define a session task?
How to join three sources using joiner?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
