Interested to Buy Any Domain ? << Click Here >> for more details...
Is it possible to update the target table with PK?
- 1 Answers
- 6437 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 issues you have faced in your project? How did you overcome those issues?
What is decode in static cache?
Explain pushdown optimization $pushdownconfig parameter - informatica
if we have a delimiters at unwanted places in a flat file how can we over come those.
Differentiate between router and filter transformation?
What are the types of schemas we have in data warehouse and what are the difference between them?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
what is the size of your data warehousing?
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?
What is Session and Batches?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
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.
What are the different clients of powercenter?
What is meant by LDAP users?
Tell me about Propagate functions in informatica
