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...

How will you update the first four rows and insert next
four rows in a mapping?

Answer Posted / shyam

from source qualifier trf take a exp trf with a sequence gen
and from there give it to filer trf. write there a condition
next value<=4 and give it to update stategy trk. and there
give condion as dd_insert and then to targer,this all comes
in first pipeline.

in second pipeline drag the ports from exp trf and again
take a filter trf,over there give condion as next_val>4 and
next_val<9. give this to update trf and then to targer.

try this .i hope u vl get the o/p.
if im wrong plz let me know

shaym

Is This Answer Correct ?    12 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the etl program with few examples.

1051


How do you set a varible in incremental aggregation

1891


What do you mean by worklet?

1066


Differentiate between a database and data warehouse?

1145


What are the different types of olap? Give an example?

1057


What is a pre-defined event and user-defined event?

1038


Enlist the various types of transformations.

1058


Differentiate between Load Manager and DTM?

2154


What is confirmed fact in dataware housing?

6970


Did u used latest transformations of 8.6.0? for what?

1882


What is decode in static cache?

1181


Explain why we use partitioning the session in informatica?

1095


What is the session task and command task?

1061


What do you mean by blocking transformation?

1041


What are the different components of powercenter?

1055