Interested to Buy Any Domain ? << Click Here >> for more details...
if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups
what is the o/p in the target
- 5 Answers
- 8659 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / moorthy g
Source have 10 Records
Router
I>2 3,5...10 (Tgt1)
I=5 ONLY 5 (Tgt2)
I<2 1-2 (Tgt3)
| Is This Answer Correct ? | 14 Yes | 5 No |
Answer / shyam reddy
Total 10 records will come. When we use Router t/r each
record will pass through every group. If it is not satisfied
any user defined conditions it will go to the Default group.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / ravi sagar
Router
I>2 3,5...10 (Tgt1)
I=5 ONLY 5 (Tgt2)
I<2 only 1 (Tgt3)
| Is This Answer Correct ? | 10 Yes | 3 No |
The above scenario I took an one table like emp table, I
took the coloumn as deptno ,I have created 3 targets and
created one router T/r , condition like that one is
deptno>20 , deptno=20 and deptno<30.
In that if the deptno>20 condition satisfies then the
particular record who has deptno above 20 which can be
loaded into one target. The same as other 2 conditions. If
the condition satisfied then it can loaded to particular target.
if it wrong means please mail me chandranmca2007@gmail.com
| Is This Answer Correct ? | 1 Yes | 1 No |
Briefly describe lookup transformation?
what is surrogate id ?
Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?
How the dimensions will be loaded?
What is fact table? Explain the different kinds of facts.
sorce is a flatfile only 1st and last row should insert to target how will u do?
Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?
Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance
What are the different types of schemas?
how to get the only updated records in the target
waht type of interface is used for testing the data in informatica
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
Teradata 
