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
Differentiate between source qualifier and filter transformation?
Name the different lookup cache(s)?
can we override a native sql query within informatica? Where do we do it? How do we do it?
How can we improve session performance in aggregator transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
How can we remove the duplicates from flat file source?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
difference between informatica 8.1.1 and 8.6
What is the function of union transformation?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Describe an informatica powercenter?
What are the different options available for update strategy?
What is a stored procedure transformation?
How can we update a record in the target table without using update strategy?