How to eliminate 1st and last rows from the source and load
the inbetween rows.
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 the function of look up transformation?
What do think which one is the better joiner or look up?
can anyone suggest best free Talend data integration training online
Can we create a Integration service without a Repository service and vice versa?
Explain what are the different types of transformation available in informatica.
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Enterprise data warehouse your projects phase by phase explain?
What is olap (on-line analytical processing?
How you can differentiate between connected lookup and unconnected lookup?
How does a sorter cache works?
What is union transformation in informatica?
Explain the scenario which compels informatica server to reject files?
what is Active lock explain
Why is sorter an active transformation?
How can we use batches?