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
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
Define the various join types of joiner transformation?
What are the types of presistent cache in look up tr.
Differentiate between a database and data warehouse?
What is the different lookup cache(s)?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Is there any way to read the ms excel datas directly into informatica?
Explain in detail scd type 2 through mapping.
Explain how to import oracle sequence into informatica?
Clarify the utilization of aggregator cache record?
Mention few advantages of router transformation over filter transformation.
What is the meaning of decode in informatica?
Explain pushdown optimization $pushdownconfig parameter - informatica
How to generate sequence numbers without using the sequence generator transformation?
How can we update a record in the target table without using update strategy?
How do you load only null records into target? Explain through mapping flow.