Answer Posted / 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 |
Post New Answer View All Answers
what is degenerated dimension?
Explain the scenario which compels informatica server to reject files?
Parameter and variable differences
Which files are created during the session rums by informatics server?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is meant by lookup transformation? Explain the types of lookup transformation?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Is it possible to define a single node as a Gateway node as well as worker node?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is a surrogate key?
What is a joiner transformation?
What are the types of schemas we have in data warehouse and what are the difference between them?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What are the components of workflow manager?
