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
Differentiate between a database and data warehouse?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How to extract the informatica rejected data?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is the procedure for creating independent data marts from informatica 7.1?
What is the difference between stop and abort in informatica
Why do you use Mapping Parameter and mapping variable?
Please let me know how to make Data masking in informatica..
How many numbers of sessions can one group in batches?
What is substr in informatica?
difference between informatica 8.1.1 and 8.6
Write the prerequisite tasks to achieve the session partition?
Explain the aggregator transformation?
What is a passive transformation?