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
What is lookup change?
In which transformation you cannot drag ports into it?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Is it possible to use a client with different version than that of its Informatica server?
Explain what are the different types of transformation available in informatica.
What do you understand by term role-playing dimension?
In warehouses how many schemas are there?
is it possible to index the data in cache of lkp transformation ?
What is the format of informatica objects in a repository?
Enlist the tasks for which source qualifier transformation is used.
What are some examples of informatica etl programs?
What are active and passive transformations?
Explain lookup transformation source types in informatica
How to do the error handling of if ur source is flatfiles?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?