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
- 8805 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
What all join we can perform in LOOKUP transformation?
How to extract sap data using informatica?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Explain the code page compatibility?
What is main use of mapplet?
what is the size of your data warehousing?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
what is song in infrmatica...?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What do think which one is the better joiner or look up?
What is a surrogate key?
what is mean by complex business rule ?
What is rank index in rank transformation?
Differentiate between a repository server and a powerhouse?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
