without using rank transformation how can we rank items by
using some other transformations
Answer Posted / bhupal
Use sorter t/r first and sort the data by using which port
u want
next use that expression t/r to generate the sequence by
using variable port
next u can use the filter t/r to restrict the data or
required ranks as a output.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What do you understand by a term domain?
What is the status code in stored procedure transformation?
What is flashback table ? Advance thanks
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Explain about cumulative Sum or moving sum?
Define update strategy?
In informatics server which files are created during the session rums?
What is meant by pre and post session shell command?
How do you load only null records into target? Explain through mapping flow.
What is informatica powercenter repository?
What does cheating measurement mean?
Separate from a database, an information bazaar, and an information stockroom?
Mention a few design and development best practices for informatica?