suppose we have 1 to 10 records.In router transformation we
had given two condition
A>= 5
A<=5
then what will be the output?
Answer Posted / mike
If you create two groups in the router transformation and
you want to load the records in to two target tables then
src-->srcq--->router-->/t1
\t2..The records which meet the
condition in the first group will pass in to the T1 and the
records which meet the condition in the second group will
pass in to the T2...i mean to say all the records that
matches the condition will come as an output
correct me if i was wrong
| Is This Answer Correct ? | 7 Yes | 6 No |
Post New Answer View All Answers
Why filter transformation is an active one?
What is depict expression change?
According to his methodology what all you need before you build a datawarehouse
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Describe data concatenation?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Explain the difference between mapping parameter and mapping variable?
Under what condition selecting sorted input in aggregator may fail the session?
What are the components of Informatica? And what is the purpose of each?
What is standalone command task?
Define mapplet?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Explain the tuning lookup transformation - informatica
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?