in my source table i want to delete first and last records and
load in between records into target? how can it possible?
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 if the source is a flat-file?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How can we use batches?
can we override a native sql query within informatica? How do we do it?
What are the new features of informatica 9.x developer?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Explain how many types of dimensions are available in informatica?
tell me the rules and responsblites in our project(my project is development)
What is the cumulative sum and moving sum?
Differentiate between Load Manager and DTM?
What are the mapping parameters and mapping variables?
What is the difference between a repository server and a powerhouse?
Where do we use mapping variables in informatica?
What could be the possible resons of locks by user?
What is workflow? What are the components of workflow manager?