Interested to Buy Any Domain ? << Click Here >> for more details...
in my source table i want to delete first and last records and
load in between records into target? how can it possible?
- 3 Answers
- 10159 Views
- HCL, Thomson Reuters, I also Faced
- E-Mail Answers
Answer Posted / venkatesh
the flow will be like this
sequence generetor
|
source--->sq--->aggrigator---->filter--->target
generate sequence number using the sequence generator
connect it to the aggrigator and the flow from sq.group by
sequence num and create two o/p ports
1)min(seqnumber)
2)max(seqnumber)
in filter write the condition as
seqnumber<>min AND max
connect the required ports to the target
u will get the required o/p
| Is This Answer Correct ? | 17 Yes | 7 No |
Post New Answer View All Answers
What do mean by local and global repository?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How to open an older version of an object in the workspace?
What is xml source qualifier transformation in informatica?
What do you mean by channel change?
How you know when to use a static cache and dynamic cache in lookup transformation?
What are mapplets? How is it different from a Reusable Transformation?
What is the difference between a connected look up and unconnected lookup?
Why update strategy and union transformations are active?
What are the popular informatica products?
Explain the scenario which compels informatica server to reject files?
What is pmcmd command?
What is Cognos script editor?
How we can create indexes after completing the loan process?
How do you change a non-reusable transformation to reusable transformation?
