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

Can yoU use the maping parameters or variables created in one maping into another maping?

2 Answers  


What is A complex mapping?

3 Answers   TCS,


Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle

1 Answers  


Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?

1 Answers  


Can anyone tell me the new features in Informatica 9 Version?

2 Answers   Syntel,


Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution

2 Answers  


h0w many versions have been developed of onformatica so far?

1 Answers   TCS, TetraSoft,


How to load a Dimension ? and how to load a fact table?

0 Answers  


In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

1 Answers   Wipro,


which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,


What is a design?

1 Answers  


Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?

6 Answers  


Categories