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
- 10010 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
How to handle decimal places while importing a flatfile into informatica?
How many ways are there to create ports?
What are the types of presistent cache in look up tr.
Explain the shared cache and re-cache?
Explain what transformation and how many are there in informatica?
What are the different transaction levels available in transaction control transformation?
How do you migrate data from one environment to another?
Explain the pipeline partition with real time example?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Differences between connected and unconnected lookup?
What is workflow? What are the components of workflow manager?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is the reusable transformation?
How can we use mapping variables in informatica?
Whats there in global repository
