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
- 11637 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 IQD file?
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
What is intricate mapping?
Explain Dataware house architecture .how data flow from intial to end?
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
in static and dynamic which one is better
my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times
How can we get multiple output values using an unconnected lookup transformation?
How can we delete duplicate rows from flat files?
How will you convert rows into columns or columns into rows
Teradata 
