how to get the first row without using rank t/r?
Answer Posted / venkatgiri
select * from Table_name limit 1
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Explain the etl program with few examples.
What is the Process to creating lookup transformation in informatica
What are the tasks that source qualifier perform?
How would you copy the content of one repository to another repository?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How can we use mapping variables in informatica? Where do we use them?
Can we override a native sql query within informatica?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Parameter and variable differences
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.
How do you promote a non-reusable transformation to reusable transformation?
What are the components of Informatica? And what is the purpose of each?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How to generate sequence numbers without using the sequence generator transformation?