Answer Posted / mike
session override is an option in informatica at session
level. Here we can maually give an sql query which is
issued to the database when the session runs. It is nothing
but over riding the default sql which is generated by a
particular transformation at mapping level.
correct me if i was wrong
| Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
When do you use sql override in a lookup transformation?
What does “tail –f” command do and what is its use as an Informatica admin.
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Write the advantages of partitioning a session?
What are the components of the workflow manager?
How to handle decimal places while importing a flatfile into informatica?
Which development components of informatica have the highest usage?
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
State the differences between sql override and lookup override?
How might one distinguish in the case of mapping is right or not without associating session?
What are 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 unit testing?tell me proceedure
write a query to retrieve the latest records from the table sorted by version(scd)
Can anyone tell me the new features in Informatica 9 Version?
What does update strategy mean, and what are the different option of it?
