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
- 8779 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
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is the different lookup cache(s)?
Explain the scenario which compels informatica server to reject files?
How can you increase the performance in joiner transformation?
What are the tasks that source qualifier perform?
What is meant by pre and post session shell command?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Explain pmcmd command usage in informatica
How do you load only null records into target? Explain through mapping flow.
What is the use of source qualifier?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
How to differentiate between the active and passive transformations?
What are active and passive transformations?
