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

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

Question Posted / soumya

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

By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?

14 Answers   CSC, Emphasis,

In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,

Define informatica repository?

2 Answers   Wipro,

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers   Infotech,

From where we can start or use pmcmd?

3 Answers  




Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it

1 Answers  

Roles and Responsibilties of Informatica Production Support Member?

6 Answers  

draw informatica architecture 8.6 ?

0 Answers   Cognizant, TCS,

What is a surrogate key?Why we use it in a mapping?Pl give an example.

4 Answers   PCS,

if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target

5 Answers   TCS,

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

1 Answers   IBM,

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

0 Answers  

For more Informatica Interview Questions Click Here
Categories