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 flat file it contains 'n' number of records, i need
to send half of the records to one target table and
Remaining half to another target table: pls full details

Answer Posted / babu

Frnds small change in the above answer..

i.e: GRP1 :O_SEQ1>=O_SEQ2 ,GRP2: O_SEQ1<O_SEQ2
OR
GRP1 :O_SEQ1>O_SEQ2 ,GRP2: O_SEQ1<=O_SEQ2

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to update source definition?

1087


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2066


How can we use mapping variables in informatica? Where do we use them?

1200


Mention few advantages of router transformation over filter transformation.

1023


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1132


Clarify the utilization of aggregator cache record?

1001


Explain lookup transformation source types in informatica

1098


Please let me know how to make encryption and decryption with example?

1900


Explain the difference between mapping parameter and mapping variable?

1038


Explain sessions and how many types of sessions are there?

1009


define galaxy repository in informatica

2228


Under which circumstances, informatica server creates reject files?

1095


What will be the approach?

979


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6490


can we override a native sql query within informatica? How do we do it?

1126