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???
- 5 Answers
- 11789 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is a surrogate key?Why we use it in a mapping?Pl give an example.
Difference between session variables and workflow variables?
What is informatica?
How to do Integration testing in Informatica?
what transformations are used for Variable port?
can anyone suggest best free Talend data integration training online
suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer
How to generate the HTML output using Informatica.
How to create the source and target database connections in server manager?
What is the difference between STOP and ABORT options in Workflow Monitor?
how to we create datamart?
Teradata 
