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


If i havee 3records in my source having same deptno like

Deptid Deptno
------ ------
101 10
201 10
301 10
and i am using router TR to loading these records into
target.Then how many record'll be loaded into target???

Answers were Sorted based on User's Feedback



If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 ..

Answer / ankit kansal

Hi,
If you are using a RTR trans and defualt value is true then all the three records get loaded into the target without any problem.


http://deepinopensource.blogspot.com/

Is This Answer Correct ?    8 Yes 0 No

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 ..

Answer / ankit kansal

The Question is not clear enough..can u be more elaborative..

http://deepinopensource.blogspot.in/

Is This Answer Correct ?    4 Yes 0 No

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 ..

Answer / ravikumar2614

if we didnt put any filter condition in trt then it will load all 3 records.

Note: For all transformations having passive nature by default.

Is This Answer Correct ?    0 Yes 0 No

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 ..

Answer / dave

All 3 records unless DEPTNO is unique constrain and then
you'll get 'Error' and only one records will be loaded
(random record Router is not sorting)

Is This Answer Correct ?    0 Yes 0 No

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 ..

Answer / ran

yes mr Ankit i aslo thought like that when he asked me this question........
but i can clarify u just tell what u need more to know abt this qstn??

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Informatica Interview Questions

what are the Methods For Creating Reusable Transformations?

0 Answers   Informatica,


If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?

2 Answers   IBM, WalMart,


what happens when a batch fails?

3 Answers  


What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

4 Answers   Cap Gemini, IBM,


What is a predefined event?

0 Answers  


In ur current projectu have done any performance tuning of mappings?

1 Answers  


lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers   IBM,


Is there any target staging area in informatica not staging area

0 Answers   Syntel,


Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?

2 Answers  


why we are using level option in normalizer transformation

1 Answers   TCS, Wells Fargo,


From where you extract the data, how you did it into informatica? explain....

1 Answers   Accenture, Unisoft Infotech,


what type of documents you receiving from client later wt can you do? what type of documents have to prepare?

2 Answers   CGI,


Categories