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
- 9867 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 advantages of using informatica as an etl tool over teradata?
What is sequence generator transformation in informatica?
Could you explain what is enterprise data warehouse?
what is song in infrmatica...?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Differentiate between sessions and batches?
Where do we use mapping variables in informatica?
What is expression transformation?
What are active and passive transformations?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Explain Dataware house architecture .how data flow from intial to end?
Design time, run time. If you don't create parameter what will happen
What are mapplets? How is it different from a Reusable Transformation?
What is blocking transformation?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
