how to get the first row without using rank t/r?
- 7 Answers
- 10572 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / venkatgiri
select * from Table_name limit 1
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is meant by a domain?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is the difference between source qualifier transformations source filter to filter transformation?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Is there any way to read the ms excel datas directly into informatica?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
How union transformation is used?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How will the document be delivered to me?
How identifying bottlenecks in various components of informatica and resolving them?
What is decode in informatica?
What are the databases that informatica can connect to windows?
without table how to come first record only in oracle?
