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

How do you implement scheduling in Informatica?

1 Answers  

What is log file,and where is it located,why u r using the log file

1 Answers   TCS,

what is polling?

1 Answers   Informatica,

I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?

6 Answers   TCS,

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

0 Answers  




i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.

3 Answers  

wt is inline view? when and why we Use ?mail to rayallarv@gmail.com

2 Answers  

what are the types of facts with Examples?

3 Answers  

hi real timers . iam waiting for ur reply regarding ETL TESTING

0 Answers  

How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 Answers  

How to do unit testing in informatica?

0 Answers  

What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.

4 Answers   JPMorgan Chase,

For more Informatica Interview Questions Click Here
Categories