Interested to Buy Any Domain ? << Click Here >> for more details...
In a table, 4 person having same salary. How to get Third
person record only?
- 15 Answers
- 21724 Views
- I also Faced
- E-Mail Answers
Answer Posted / saumyabrata
1>Use a Sequence Generator Transformation,selet Start value
= 1 and Increment By = 1.
2>Use a Filter Transformation,take the ports Person and
Salary from source qualifier and the NEXTVAL port from
Sequence Generator Transformation into it.Set the filter
condition NEXTVAL = 3.
You are done.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
During the running session, output files are created by informatica server. Enlist few of them.
To import the flat file definition into the designer where should the flat file be placed?
How to implement security measures using repository manager?
Explain the difference between a data warehouse and a data mart?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is decode in informatica?
What are the settings that you use to configure the joiner transformation?
Can we get 1st record through Informatica(without sequence number).
What is an Integration service in Informatica?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Where are the source flat files kept before running the session?
What is the cumulative sum and moving sum?
