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
- 8651 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
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Define enterprise data warehousing?
How do you migrate data from one environment to another?
What are the informatica performance improvement tips
How can we update a record in the target table without using update strategy?
Can anyone tell me the new features in Informatica 9 Version?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Design a mapping to load the cumulative sum of salaries of employees into target table?
In which transformation you cannot drag ports into it?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are the steps involved in the migration from older version to newer version of Informatica Server?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
lookup transformation with screenshots
How do you load only null records into target?
What are roles and groups and benefits of using them?
