What is the difference between Connected and UnConnected
Lookup Transformation.Give me one or two examples please?

Answer Posted / guest

CONNECTED T/S RECIVES MULTIPLEINPUTS AND PROVIDES MULTIPLE
OUTPUTS
SUPPORTS USERDEFINED VALUES
USE DYNAMIC CACHE
AND IF U WANT TO USE THE SAME LOOK UP MULTIPLE TIMES IN
THE MAPPING U CAN GO FOR UNCONNECTED
IT RECIEVES INPUT FROM THE RESULT OF AN EXPRESSION
TRANSFORMATION AND PROVIDES SINGLE OUTPUT
DOES NOT SUPPORT USER DEFINED VALUES
USES STATIC CACHE

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are the different versions of informatica?

855


Explain joiner transformation in informatica

877


what are the Methods For Creating Reusable Transformations?

865


Differentiate between source qualifier and filter transformation?

1268


What is option by which we can run all the sessions in a batch simultaneously?

865


What is union transformation?

735


Describe an informatica powercenter?

798


i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1883


Mention some types of transformation?

797


What is the benefit of partitioning a session?

864


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2058


whats the logic to load the lower level of granularity of data to fact table.

2029


What is the sql query overwrite in source qualifier in informatica

812


What do you mean by channel change?

743


Explain target update override in informatica

836