what is session override?
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 |
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
What is the fact table?
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?
Explain transaction control transformation in informatica
In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data
i want excute multiple sessions in one workflow using the "start task".what do i need to do?
Define informatica repository?
in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?
hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you
can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?
1 Answers Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,