Interested to Buy Any Domain ? << Click Here >> for more details...
I want load the data into target with out 1st and last record.
- 5 Answers
- 9925 Views
- Yash Technologies, I also Faced
- E-Mail Answers
Answer Posted / sree
u can override the query in SQt/r
select * from emp where rowid not in ((select min(rowid)
from emp),(select max(rowid) from emp))
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
How many ways are there to do 'remove duplicate records in informatica'?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is rank transform?
Why do we need informatica?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is a predefined event?
What is dynamic cache?
Explain the etl program with few examples.
Explain lookup transformation is active in informatica
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
What is decode in informatica?
What is a sorter transformation?
What is the function of aggregator transformation?
What is lookup transformation?
What are junk dimensions?
