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 is the maplet?
Could you explain what is enterprise data warehouse?
What is the commit type if you have a transaction control transformation in the mapping?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How to load a Dimension ? and how to load a fact table?
Explain sessions. Explain how batches are used to combine executions?
what is the -ve test case in your project.
What is update strategy transform?
what is the Default Source Option For Update Strategy Transformation?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is data movement mode in Informatica and difference between them?
What are Dimensional table?
What is informatica worklet?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Different sorts of metadata that stores in the storage facility?