Interested to Buy Any Domain ? << Click Here >> for more details...
How to eliminate 1st and last rows from the source and load
the inbetween rows.
- 5 Answers
- 26432 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / sagarreddy
in source qualifier your using this query like this u get it
easily
select rowid from tablename
minus
(select min(rowid) from tablename
union
select max(rowid) from tablename )
if u write this query will work it plz go through it
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is meant by lookup transformation? Explain the types of lookup transformation?
Performance tuning( what you did in performance tuning)
What is complex mapping?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Define mapping and session?
Explain the types of lookup transformation?
Explain why we use partitioning the session in informatica?
What is workflow monitor?
What is the cumulative sum and moving sum?
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 ?
What is standalone command task?
