on a day i load 10 rows in my target and on nextday i get
10 more rows add to my target but out of 5 are update row
how ican send them to target?how i can insert and update
the records
Answer Posted / abhinaw prakash
We can use Update strateGY TO execute the following scenario
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
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.
Explain the code page compatibility?
What is domain and gateway node?
what is the Default Source Option For Update Strategy Transformation?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What are the different types of transformation available in informatica.
How would you join a node to the already existing domain?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Make a note of the quantity vaults made in informatica?
In warehouses how many schemas are there?
What is incremental aggregation?
How to go to the older version for a mapping?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks