Interested to Buy Any Domain ? << Click Here >> for more details...
Input is like
1
1
1
2
2
3
and out put should be 1
2
3
How can u acheive using rank transformation ??
- 3 Answers
- 8806 Views
- IBM, I also Faced
- E-Mail Answers
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
What is the sql query overwrite in source qualifier in informatica
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Does an informatica transformation support only aggregate expressions?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Which transformation should we use to normalise the COBOL and relational sources?
wf dont have integration severances how you can run?
What are the differences between source qualifier and joiner transformation?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is joiner transformation?
Where are the source flat files kept before running the session?
server hot-ws270 is connect to Repository B. What does it mean?
Is it possible to use a client with different version than that of its Informatica server?
Explain what is informatica metadata and where is it stored?
Is it possible to revert a global repository to local one and why?
