Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete first 3 rows & last 3 rows in target table in
informatica
- 6 Answers
- 14595 Views
- TetraSoft, I also Faced
- E-Mail Answers
Answer Posted / civa
take seq trns and drag nextval port into exp trns and also
drag sq ports to exp
in exp delete from emp where nextval= 1 or 2 or 3 and
nextval=count(empno)-1 or count(empno)-2 or count(empno)-3
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
How to improve the performance of a session using sorter transformation?
Write the advantages of partitioning a session?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is a code page?
How to join three sources using joiner? Explain though mapping flow.
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is a snowflake schema?
How to create or import flat file definition in to the warehouse designer?
What is the way to execute pl/sql script using informatica mapping?
waht type of interface is used for testing the data in informatica
What is joiner change?
Quickly characterize reusable change?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How to load the data from people soft hrm to people soft erm using informatica?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
