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...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

i have f;latfile source. i have two targets t1,t2. i want to
load the odd no.of records into t1 and even no.of recordds
into t2.

Question Posted / jagadabhi.hima

Answers were Sorted based on User's Feedback



i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and..

Answer / abpat2203

Add a sequence generator. Next, pass the all the data along
with that from the sequence generator into a router.

In the router, use the mod fucntion on the value incoming
from sequence generator.

If the mod fucntion returns a 0, pass it to T2 and if it
returns any other value other than 0, pass it into T1.

Is This Answer Correct ?    14 Yes 0 No

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and..

Answer / akash

By using Router Transformation
SQL Server : (id%2 = 0 or 1)
Oracle : mod(id,2) = 0 or 1

Is This Answer Correct ?    0 Yes 0 No

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and..

Answer / usha

seq g
|
|
s-->sq--->RTR

in router netval=1
nextvale=2

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

3 Answers  

normalizer transformation

3 Answers   CTS,

How to compare Source and Target table, without using dynamic lookup?

4 Answers  

Informatica and datawarehousing courses in Pune?

2 Answers  

how to get the data from the client machine and how to get server location data to client loction can any body explain to me

1 Answers   TCS,

I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?

1 Answers  

Explain sql transformation in script mode examples in informatica

0 Answers   Informatica,

Define joiner transformation?

0 Answers  

Slowly changing dimensions, types and where will you use them

0 Answers  

How do you change parameter when you move it from development to production.

1 Answers  

SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?

6 Answers   IBM,

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

1 Answers   KPIT,

For more Informatica Interview Questions Click Here
Categories