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
- 8792 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 |
what is shared Cache. when we will use shared Cache?
how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)
3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?
Can you use flat files in Mapplets.
I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan
define galaxy repository in informatica
Is it possible to use a client with different version than that of its Informatica server?
what is normalization? explain 1st NF, 2nd NF, 3rd NF
i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list 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
What is the need for an etl tool?
Teradata 
