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
- 8683 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / palthepu_santosh
from source qualifier map the column(id) into two fields of
rank (id,id_grp). select grp_id as group by and rank as 1
output should be
1
2
3
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
Define mapping and session?
How can we handle two sessions in informatica?
Explain the mapping variable usage example in informatica
whats the logic to load the lower level of granularity of data to fact table.
What are the different types of repositories created using informatica?
can we override a native sql query within informatica? Where do we do it?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Why filter transformation is an active one?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What are the new features of Power Center 5.0?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Explain informatica architecture - version 8 / 9
How many transformations can be used in mapplets.
what is the hint? how to use it to reduce the query processing in program?
can anyone explain me about retail domain project in informatica?
