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 to get EVEN & ODD numbers separately?

Answer Posted / krishnakanth.ch

There are many ways....

1) Using the sql override in the source qualifier. To find
the even and odd. Add another column to flag the even and
odd.Like

select ID,decode( id/2,0,'E','O') FLAG FROM TABLE_NAME;

Using the router we can send them into two seperate target
tables.

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

wat are deployement groups in informatica, how it will be used for developers

1719


What is blocking transformation?

1145


State the differences between sql override and lookup override?

1209


What do you mean by filter transformation?

953


Can we create two repositories on same database instance in oracle?

1095


How to elaborate powercenter integration service?

1136


Performance tuning in UNIX for informatica mappings?

2568


Describe the impact of several join conditions and join order in a joiner transformation?

1063


What are pre and post-session shell commands?

1311


What is meant by LDAP users?

1210


What is intricate mapping?

1205


What is the different lookup cache(s)?

1086


What are the types of lookup transformation?

1081


Explain the different dimensions.

967


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1866