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

Answers were Sorted based on User's Feedback



how to get flatfile containg 10 records half records one target another half another target..

Answer / mahipal reddy

first create a sequence to those 10 records n using filter
or router transformation filter first 5 columns n load into
target similarly remianing 5 records.

Is This Answer Correct ?    5 Yes 0 No

how to get flatfile containg 10 records half records one target another half another target..

Answer / 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

More Informatica Interview Questions

what is the difference between stop and abort?

3 Answers   TCS,


Explain in detail about scd type 1 through mapping.

0 Answers  


How many repositories can we create in Informatica??

9 Answers   IBM, Patni,


when informatica 8 series released ?

1 Answers   IBM,


supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers   TCS, Wipro,


version controlling in informatica?

3 Answers  


How the dimensions will be loaded?

0 Answers   HCL,


what are the types of Data warehousing ?

1 Answers  


what is difference between dimention table and fact table?

1 Answers  


What are the advantages of informatica?

0 Answers  


if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,


How will u find weather dimension table is big in size of a fact table?

1 Answers  


Categories