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 do you load alternate records into different tables through mapping flow?

1850


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1244


can anyone suggest best free Talend data integration training online

1690


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?

1062


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?

6483


How do you handle two sessions in Informatica

1152


Tell me about Propagate functions in informatica

919


In which transformation you cannot drag ports into it?

1315


What is a predefined event?

1087


What is the use of source qualifier?

1120


Different circumstance which drives informatica server to expel records?

978


Enterprise data warehouse your projects phase by phase explain?

1917


Name the different lookup cache(s)?

1228


Slowly changing dimensions, types and where will you use them

1710


What is parallel processing in informatica?

1709