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
- 11438 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 are the Methods For Creating Reusable Transformations?
If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?
what happens when a batch fails?
What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?
What is a predefined event?
In ur current projectu have done any performance tuning of mappings?
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
Is there any target staging area in informatica not staging area
Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?
why we are using level option in normalizer transformation
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
Teradata 
