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

Mapping
source - SQ -> Exp T/r -> Filter -> target

Exp t/r:
create 4 variable and 3 output ports.
v_curr,v_flag,o_filter,o_flag,v_count,v_prev,0_count

v_flag = iif(v_currnt = '*' OR v_prev = '*' or flag_v=1,
1,0)
v_count = iif(v_prev='*',count+1,count)
o_filter = iif(No!= '*',1,0)
o_flag = v_flag
0_count = v_count

filter t/r:
condition: o_flag=1 AND o_filter=1 AND 0_count!=2

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Could you explain what is enterprise data warehouse?

1227


Explain the types of lookup transformation?

1107


draw informatica architecture 8.6 ?

3932


What is workflow? What are the components of workflow manager?

1233


What are the differences between oltp and olap?

1018


What are the types of lookup transformation?

1120


Explain the different lookup methods used in informatica?

1098


Explain scd type 3 through mapping.

1055


What are the popular informatica products?

1057


Explain lookup transformation source types in informatica

1153


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2108


Which is the t/r that builts only single cache memory?

1239


Explain the different kinds of facts.

1023


What are the databases that informatica can connect to windows?

1099


What are the performance considerations when working with aggregator transformation?

1209