Input is like
1
1
1
2
2
3
and out put should be 1
2
3
How can u acheive using rank transformation ??
Answer Posted / redflower
src->sq->aggregator->filter->target
from aggt/r we would calculate count(empid)
for eliminating duplicates we will write the filter condition
count(empid)=1
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
In warehouses how many schemas are there?
What are the restrictions of union transformation?
Have you worked with/created Parameter file
What are the mapping parameters and mapping variables?
Explain about cumulative Sum or moving sum?
How to generate sequence numbers?
Define mapping and session?
generate date / time dimension in informatica
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is persistent lookup cache?
Name the different lookup cache(s)?
How to do unit testing in informatica?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Performance tuning( what you did in performance tuning)