What is update override?
- 1 Answers
- 6415 Views
- Accenture, I also Faced
- E-Mail Answers
Answer / abhinav
Update Override is an option in Informatica at the session
level. In this, you can manually enter the SQL query to be
used. This query will be issued to the Database when the
session is run, overriding the SQL query generated by that
particular transformation at the mapping level.
| Is This Answer Correct ? | 9 Yes | 0 No |
What is a standalone command task?
Why the workflow is failed after running two hours in informatica?
What is informatica?
please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.
What are the out put files that the informatica server creates during the session running?
I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help
What do you understand by term role-playing dimension?
my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?
How to improve the session performance in informatica?
Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??
Teradata 
