Interested to Buy Any Domain ? << Click Here >> for more details...
what is session override?
- 2 Answers
- 12072 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Without using any transformations how u can load the data into target?
After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
How an expression transformation differs from aggregator transformation?
How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 Answers TCS, Tech Mahindra,
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
How we can confirm all mappings in the repository simultaneously?
Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep
How will u find weather dimension table is big in size of a fact table?
How do you load unique records into one target table and duplicate records into a different target table?
how can you load data into target table without leading zeor's
Describe an informatica powercenter?
Teradata 
