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???
Answer Posted / 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 |
Post New Answer View All Answers
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Differentiate between reusable transformation and mapplet.
Differences between version 7.x and 8.x.
Can anyone tell me the new features in Informatica 9 Version?
Is there any way to read the ms excel datas directly into informatica?
What is the difference between source qualifier transformations source filter to filter transformation?
Mention few advantages of router transformation over filter transformation.
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the sql query overwrite in source qualifier in informatica
What does update strategy mean, and what are the different option of it?
what is diff b/t sorter t/r and agg have the option sorter property...
Where are the source flat files kept before running the session?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
if we have a delimiters at unwanted places in a flat file how can we over come those.