what is session override?

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


Please Help Members By Posting Answers For Below Questions

How we can create indexes after completing the loan process?

838


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

727


What are some examples of informatica etl programs?

623


How to go to the older version for a mapping?

688


How can we remove the duplicates from flat file source?

657






How can one identify whether mapping is correct or not without connecting session?

1020


Explain the types of transformations?

689


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4409


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1878


How do you load alternate records into different tables through mapping flow?

1420


What are the advantages of using informatica as an etl tool over teradata?

663


what is the size of u r source(like file or table)?

1909


How to load data in informatica ?

665


Define mapplet?

708


What is the different lookup cache(s)?

712