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


Please Help Members By Posting Answers For Below Questions

What is lookup change?

613


In which transformation you cannot drag ports into it?

774


can we override a native sql query within informatica? Where do we do it? How do we do it?

595


Is it possible to use a client with different version than that of its Informatica server?

637


Explain what are the different types of transformation available in informatica.

565






What do you understand by term role-playing dimension?

566


In warehouses how many schemas are there?

576


is it possible to index the data in cache of lkp transformation ?

1517


What is the format of informatica objects in a repository?

593


Enlist the tasks for which source qualifier transformation is used.

582


What are some examples of informatica etl programs?

527


What are active and passive transformations?

645


Explain lookup transformation source types in informatica

693


How to do the error handling of if ur source is flatfiles?

1503


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1313