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
Performance tuning( what you did in performance tuning)
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are batches?
What is a sequence generator transformation?
Explain about Informatica server process that how it works relates to mapping variables?
Mention few advantages of router transformation over filter transformation.
Explain sql transformation in script mode examples in informatica
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Partition, what happens if the specified key range is shorter and longer
How to start a workflow using pmcmd command?
Repository user profiles
Explain the mapping variable usage example in informatica
How to implement security measures using repository manager?
What is target designer and target load order?