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 / ankur

small change in the above post..
add an exp after source qualifier...with two more ports

v_out as variable =iif((is_number(inputport),v_out,v_out+1)
output=v_out

so output from this exp will be
1 0
2 0
3 0
* 1
4 1
5 1
6 1
* 2
7 2
8 2
8 2

now add a filter where output=1

Thanks

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is DR strategy for Informatica project?

1226


What is InformaticaPowerCenter?

1179


What is the Rank index port in Rank transformation?

1103


how many types of dimensions are available in informatica?

1181


What are the mapping parameters and mapping variables?

1272


What are the performance considerations when working with aggregator transformation?

1210


update strategy transformation in informatica

1124


What is sequence generator transformation in informatica?

1127


Slowly changing dimensions, types and where will you use them

1773


How do we call shell scripts from informatica?

1192


what is the hint? how to use it to reduce the query processing in program?

7982


What is a joiner transformation?

1037


How to elaborate powercenter integration service?

1175


What are the features of complex mapping?

1209


What are the main features of Oracle 8i with context to datawarehouse?

2161