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
- 9814 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
Explain the difference between mapping parameter and mapping variable?
what is informatica metadata?
can anyone explain me about retail domain project in informatica?
How many ways are there to create ports?
r u done any partitions in ur project?
Explain about cumulative Sum or moving sum?
Performance tuning( what you did in performance tuning)
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What could be the possible resons of locks by user?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
permutations of mapplet
What is workflow monitor?
Which development components of informatica have the highest usage?
What is substr in informatica?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
