Interested to Buy Any Domain ? << Click Here >> for more details...
if i have a file having record sal=10000,and when use router
with two groups having condition sal>5000 in one
group,sal>7000 in other group.and if two groups connected to
two targets.in which target sal=10000 will go?
- 9 Answers
- 16745 Views
- BirlaSoft, Genpact, L&T, Syntel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sujana
record goes 2 both tables..it wil be passed multiple times
| Is This Answer Correct ? | 28 Yes | 1 No |
Answer / prakash kumar kumhar
yes record will store in both target if you r not using any column as a primary key from source column.
if u are using any column from the source as a primary than it will load only in first target i think.
| Is This Answer Correct ? | 4 Yes | 3 No |
Answer / chegu
Both records satisfying the conditions go to target
like the emp table has 14 rows,in router we pass the emp data and create 2 groups as sal_1=sal>1100 and sal_2=sal>1500 and then connect to two target tables run workflow,we get 18 records as output satisfying first and second conditions.
Thank you
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / krish
HAY JUST GO THROUGH THE Q IT GIVEN AS ROUTER
SO, IN SECOND CONDITION U WILL FINE SAL=10,000
IF ITS FILTER THEN IN BOUT CONDITION'S
U WILL FINE THE SAL=10,000
THAT IS DIFF BETWEEN
FILTER AND ROUTER
THIS IS THE GOOD SENIOR0 FOR ROUTER AND FILTER DIFF
FOR VERIFICATION USE EMP TABLE
ONCE
| Is This Answer Correct ? | 0 Yes | 3 No |
What do you mean by channel change?
What is a joiner transformation and why it is an active one?
In real time scenario where can we use mapping parameters and variables?
what is the difference between copy object import objects using repositery manager which one is best
What is a design?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence
what is threshold error in informatica?
i have 2 mapings for this 2 mapings i want use only one lookupt/r how?
Explain the features of connected and unconnected lookup.
hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.
Can you copy the session to a different folder or repository?
Teradata 
