Answer Posted / shashi
like to add a little bit.
just go to any Query editor and use DENSE rank() this will
clarify much more.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What are the steps involved in the migration from older version to newer version of Informatica Server?
How to create Target definition for flat files?
In how many ways we can create ports?
What is the sql query overwrite in source qualifier in informatica
list out all the transformations which use cache?
What is meant by a domain?
In informatica workflow manager, how many repositories can be created?
What is target load order?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Write the prerequisite tasks to achieve the session partition?
How we can use union transformation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Write the different tools in the workflow manager?
Design time, run time. If you don't create parameter what will happen