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
- 9985 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 if the source is a flat-file?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is a joiner transformation and why it is an active one?
How to differentiate between the active and passive transformations?
What is parallel processing in informatica?
What are the advantages of using informatica as an etl tool over teradata?
What is the need of an ETL tool?
How might you approve all mappings in the archive all the while?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is a difference between complete, stop and abort?
Differences between version 7.x and 8.x.
-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?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
what are the Methods For Creating Reusable Transformations?
What is meant by incremental aggregation?
