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
- 8625 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / chandrasekar
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 |
Post New Answer View All Answers
What are the limitations of joiner transformation?
How to create Target definition for flat files?
How are the sources and targets definitions imported in informatica designer?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Can we create multiple integration service on single repository?
have u done any performance tuning? how u ll do?
can we override a native sql query within informatica? How do we do it?
Define mapplet?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
How to extract sap data using informatica?
How do you convert single row from source into three rows into target?
How can we use mapping variables in informatica?
What are the different types of transformation available in informatica.
How to create the source and target database connections in server manager?
How many ways are there to create ports?
