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 batches?

0 Answers  


Separate from a database, an information bazaar, and an information stockroom?

0 Answers  


Can a joiner be used in a mapplet.

1 Answers  


we have to use order by,where,having we to implement sql query

1 Answers   Satyam,


Name 4 output files that informatica server creates during session running?

1 Answers  


State the limitations where we cannot use joiner in the mapping pipeline?

0 Answers  


Explain joiner transformation in informatica

0 Answers   Informatica,


who is the best faculty for informatica in hyderabad ameerpet?

1 Answers  


Write the prerequisite tasks to achieve the session partition?

0 Answers  


How to update a particular record in target with out running whole workflow?

0 Answers  


Scheduling properties,whats the default (sequential)

0 Answers  


Define mapplet?

0 Answers  


Categories