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 you count the number of records available at your source?
what is the size of u r project? and what is the size of source file?
How do you recover rows from a failed session
what are the real time problems generally come up while doing or running mapping or any transformation?
What is the Router transformation?
have u done any performance tuning? how u ll do?
How to improve the session performance in informatica?
Explain what transformation and how many are there in informatica?
What are the phases in SDLC?
How can yoU improve session performance in aggregator transformation?
In target table how to display the system time
tell me 7.x and 8.x diferrencess(but not transformations)