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 saini

hey guys c if this works...

add an exp after source qualifier...with two more ports

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

so output from this exp will be
1 0
2 0
3 0
* 1
....
* 2
...

now add a filter where output>0

Thanks

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2081


The question was on time stamp. what is the difference between HH and HH24 when to use when.

1996


What are the differences between oltp and olap?

923


What is the difference between a connected look up and unconnected lookup?

911


can we override a native sql query within informatica? Where do we do it? How do we do it?

1014


What is an Integration service in Informatica?

1084


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8130


What are the mapping parameters and mapping variables?

1090


What are multi-group transformations?

1013


What does refresh system mean, and what are its distinctive choice?

1075


How might one distinguish in the case of mapping is right or not without associating session?

1028


How to implement security measures using repository manager?

1084


What is session task and command task?

1182


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

971


What are the types of caches in lookup? Explain them.

921