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

i have a source with 100 records.i have 2 targets.in the first
target i want to load first 50 records & in the second target
i want to load next 50(or remaining) records.

Answer Posted / kamleshmishra291

After SQ take expression and add port
v_Sequene=v_Sequence+1
o_Sequence=v_Sequence
Take Router Transformation and add two groups
Group1 = o_sequence<=50
Group2=o_sequence>50
Connect Group1 and Group2 to Target1 and Target2

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the scenario which compels informatica server to reject files?

1075


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2166


What is an Integration service in Informatica?

1136


What is a code page?

1182


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.

2282


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

2060


What are the new features of informatica 9.x in developer level?

1002


What are the different ways to implement parallel processing in informatica?

1429


Explain the types of transformations?

1073


What is the format of informatica objects in a repository?

1021


What is union transformation in informatica?

1151


 Informatica Checkpoints

3334


Explain the different kinds of facts.

987


What is the advantage of informatica?

1069


What is the difference between Active and Passive transformation?

1157