How to eliminate 1st and last rows from the source and load
the inbetween rows.
- 5 Answers
- 24239 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
Explain scd type 3 through mapping.
What are the data movement modes in informatica?
What is depict expression change?
Which is the t/r that builts only single cache memory?
How does a rank transform differ from aggregator transform functions max and min?
Please let me know how to make encryption and decryption with example?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
explain about unit testing? in real time?
How might you approve all mappings in the archive all the while?
How to do unit testing in informatica? How to load data in informatica ?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
Explain the code page compatibility?
What is meant by LDAP users?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
