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 flatfile containg 10 records half records one
target another half another target

Answer Posted / gazulas

what if the number 10 changes??

use a sql transfermation and get the record count or use an agg get rec count and pass it into record_count. use seq gen and populate the numbers. then use a router and write condition seq no <= record_count/2 -- target1

default to target 2.

this will work even ur records changes to 100 or 25o or 40000..etc

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1556


What is source qualifier transformation in informatica?

947


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1050


During the running session, output files are created by informatica server. Enlist few of them.

931


Clarify the utilization of aggregator cache record?

943


What does update strategy mean, and what are the different option of it?

1035


What is a dimensional model?

927


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10630


define galaxy repository in informatica

2154


Can we create a Integration service without a Repository service and vice versa?

1172


what is INFORMATICA TESTING process

2226


What are the static cache and dynamic cache in informatica?

1139


What is olap (on-line analytical processing?

1007


What is meant by query override?

1005


Global and Local shortcuts. Advantages.

1957