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???
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 |
Can yoU use the maping parameters or variables created in one maping into another maping?
What is A complex mapping?
Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
Can anyone tell me the new features in Informatica 9 Version?
Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution
h0w many versions have been developed of onformatica so far?
How to load a Dimension ? and how to load a fact table?
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
What is a design?
Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?