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
- 10179 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 are the differences between oltp and olap?
What is incremental aggregation?
What is data movement mode in Informatica and difference between them?
What is InformaticaPowerCenter?
In informatics server which files are created during the session rums?
What is the difference between writing a joiner query in ANSI style and THETA style?
Where is metadata stored?
Explain how to import oracle sequence into informatica?
What are the different components of powercenter?
What is a filter transformation?
What is a joiner transformation and why it is an active one?
What are the guidelines to be followed while using union transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How to Create a folder using pmrep command?
