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

How can i send first half of the records to one target and
Remaining to other target?

Answer Posted / abhinaw prakash

Ypu can write this query in the SQL override.

select * from table_name where rownum < (select
max(rownum)/2) from employees).


Also you can write the same logic in Router and develop a
mapping.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Reusable transformation and shortcut differences

1884


Mention some types of transformation?

1098


How to use pmcmd utility command?

1077


What are active and passive transformations?

1134


What is meant by lookup transformation? Explain the types of lookup transformation?

1022


Explian the Process of deployment groups in informatica

1102


What do you mean by blocking transformation?

1119


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6282


tell me 5 session failure in real time how can you solve that in your project?

2393


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2350


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1123


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2072


What are the measure objects?

1256


what is degenerated dimension?

4096


How can repository reports be accessed without sql or other transformations?

1268