Interested to Buy Any Domain ? << Click Here >> for more details...
I have a condition sal=100 and I created one router and in
that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100,
first which condition will satisfy, and Why?
- 11 Answers
- 24352 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajasekar c
Sal=100 will satisfy both groups bcz in Infrmatica,all the
records are checked for all the group conditions,where ever
it satisfy the condition it goes to that group.(It is not
like if ... else).
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / rajasekar c
No Murali.. Here, if the sal=100 then it will goes to both
g1 and g2.That is why I mentioned "It is not like
If..else".
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / rajasekar c
Jegan ... It will go to both groups ... That is why I
mentioned that it is not like If ... else ...
If you still have doubt then just check with some test
files ...
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / rashmi garg
this row (sal =100) will satisfy both the conditions and
will be routed to the transformation or target of both the
groups
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / pramod
Yes, raj is right, its not like if one condition satisfies
it wont go to next condition, in informatica it will check
with all the groups whatever it satisfies then record will
pass, can try this.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / prasanna
in router t/r if row meets more than one condition
informatica server passes that row multiple times
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / nadeem khan
As we know that Router is an active transformation and here is the example to suits that properties. In Router, condition will check for each group simultaneously. and where ever it satisfies, record will route from those groups.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nishanth
yes, in router it will satisfy and transferred to both groups , but is this the same scenario with lookup also?
can any one tell ?
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ram patil
Only display record both conditions are not executed
SQ->FILTR->RTR>TRG1>TRG2
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / murali
it will work on SAL<=100 firstly, as if we have put this
condition in the G1 group. and for the remaining, there is
no need to give any condition. remaining all will fall
under SAL>=100 only. these records, u can get them into the
target from the default group...
| Is This Answer Correct ? | 0 Yes | 8 No |
What is native users?
source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in
Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks
Scheduling properties,whats the default (sequential)
how to load duplicate row in a target
Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
What is the procedure for creating independent data marts from informatica 7.1?
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
What are the limitations of joiner transformation?
How can you run a session without using server manager?
Teradata 
