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

Create a mapping which contains 2 target tables. When the
session runs for the first time it shud load Target table 1
and when it runs for second time it shud load Target
table 2.

Answer Posted / triveni munnangi

source_>sq->expression->router->tg1
->tg2
expression:v_count decimal 10 0(variableport) setvariable($$cnt,1)
o_count decimal 10 0 (outputport) $$cnt
router:groups
t1=o_count=0
0_count=1
$$cnt variable integer 10 0 max false

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are the different types of transformation available in informatica.

1038


How to update a particular record in target with out running whole workflow?

1533


tell me the rules and responsblites in our project(my project is development)

1874


can u give example for factless fact table

6441


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2677


Write the different tools in the workflow manager?

993


Is there any way to read the ms excel datas directly into informatica?

977


What is the use of code page?

1010


How you can differentiate between connected lookup and unconnected lookup?

1006


wf dont have integration severances how you can run?

1883


In which transformation you cannot drag ports into it?

1243


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2224


What is the different lookup cache(s)?

1034


What are the tasks that can be performed using sq?

1023


What is standalone command task?

1260