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
- 11551 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 |
what is bridge tables in informatica
What are the tuning techniques you applied during your last project
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Can we use the mapping parameters or variables created in one mapping into another mapping?
how to remove staging area
What are the join types in joiner transformation?
what is incremental loading ?
12 Answers CTS, IBM, Oracle, TCS,
What is parallel processing in informatica?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
Target increases every day even though no new record was inserted
what is metadata?
How to differentiate between the active and passive transformations?
Teradata 
