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
2
3
*
4
5
6
*
7
8
9

how to load records between two stars(*),

Answer Posted / guest

u can use mapping variable in exp transformation.
and do
decode(v_curr='*' or v_prev='*',setvariable($$,$$+1),$$)
and last port in exp setvariable($$,0) and accrdingly filter the non required...

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2371


What are the issues you have faced in your project? How did you overcome those issues?

2413


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.

1339


How can a transformation be made reusable?

1239


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1339


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1231


Define filter transformation?

1149


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2153


What all are steps in up gradation of Informatica server?

1096


can anyone suggest best free Talend data integration training online

1745


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1321


Does an informatica transformation support only aggregate expressions?

1088


What are mapplets?

1329


What are the advantages of using informatica as an etl tool over teradata?

1077


What you know about transaction control transformation?

1059