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

Informatica settings are available in which file?

0 Answers   Informatica,

hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.

2 Answers   IBM,

my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4

2 Answers   Zensar,

tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use

1 Answers  

How do you remove duplicate records in informatica?

1 Answers  

Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.

7 Answers   Cognizant, Wipro,

How can u work with remote database in informatica?did you work directly by using remote connections?

2 Answers  

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

4 Answers   TCS,

which one is better either active or passive transformation in informatica

1 Answers  

What is status code in informatica?

0 Answers  

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

0 Answers  

The question was on time stamp. what is the difference between HH and HH24 when to use when.

0 Answers   Nationwide,

For more Informatica Interview Questions Click Here
Categories