How can we get two output ports in un-connect transformation?

Answer Posted / prabhu

You can use lookup override to concat two columns from tble
and return as single column(eg COL1||','||col2 as
COLUMN).You can pass this to expression transformation and
parse it to split it again

Prabhu
www.iskilltech.com

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is mapplet in informatica?

598


What are the different options available for update strategy?

580


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1483


Slowly changing dimensions, types and where will you use them

1278


State the limitations where we cannot use joiner in the mapping pipeline?

553






How to implement security measures using repository manager?

608


Write the program through which the records can be updated?

520


On which transformations you created partitions in your project?

763


What are the different types of repositories created using informatica?

663


How do you manage the Parameter files while migrating your data from one environment to another environment?

555


What are the types of schemas we have in data warehouse and what are the difference between them?

527


Is it possible to create multiple domains on a single Informatica server?

760


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

645


Clarify the aggregator change?

600


What are the new features of informatica 9.x in developer level?

568