i hav a scenario like this i want load data from source to
target as follows frist it counts the num of deptno and
display with that with count and how many times it reapts
along with all the records in source
Answer / santha
for this scenario You can use the ANALYTIC function.It give
all the total count and individual count...
| Is This Answer Correct ? | 2 Yes | 0 No |
how we can update a target table without update strategy and update override?
How to load data in informatica ?
What is the difference between Normal load and Bulk load?
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
What is xml source qualifier transformation in informatica?
What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?
What is Session and Batches?
What's the layout of parameter file (what does a parameter file contain?)?
What are the out put files that the informatica server creates during the session running?
Explain one complecated mapping?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
Why we need XMLs?