Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

How to delete first 3 rows & last 3 rows in target table in
informatica

Question Posted / santosh kumar sarangi

Answer Posted / santosh kumar sarangi

create a sequence t/r and link the next value with sq t/r to
expression t/r and. Create two link.
First Link:
Connect ex t/r to update strategy t/r and keep condition as
IIF(NEXTVAL<4,DD_DELETE,DD_REJECT) and connect to target
except the nextval column.
Second Link:
Connect to sorter t/r and sort with descending order of
nextval and rename as in_nextval. create new sequence
generator and link to the same ex t/r. Link the ports to
again one more update strategy t/r and keep the same condition
as IIF(NEXTVAL<4,DD_DELETE,DD_REJECT) and link to the one
more instance of target table.

Let me know if any things wrong.

Thanks & regards,
Santosh Kumar Sarangi

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Global and Local shortcuts. Advantages.

1957

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1133

How to elaborate powercenter integration service?

1072

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1057

What is complex mapping?

1068

What are the differences between source qualifier and joiner transformation?

993

Describe data concatenation?

1005

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1506

server hot-ws270 is connect to Repository B. What does it mean?

2439

Explain dynamic target flat file name generation in informatica

1008

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1102

What are ETL Tools?

1040

How many dimensions are there in informatica?

1023

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1986

What is informatica worklet?

987