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
- 8451 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 |
why dimenstion tables are denormalized in nature ?
can we use self join in informaitca?
What is a look up function? What is default transformation for the look up function?
What are the different types of transformation available in informatica.
Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?
how to get the only updated records in the target
I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me
What is the difference between sequential batch and concurrent batch and which is recommended and why?
One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?
Why we use partitioning the session in informatica?
Teradata 
