in unconnected lookup , what are the other transformations ,
that can be used in place of that expression transformation ?

Answer Posted / anil

u can use any T/r based on Exp editor available in which
t.r that t/r u can use .lkp value.u can use
update ,agg,rank,filter,sq

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the function of look up transformation?

842


what is the Default Source Option For Update Strategy Transformation?

956


How to convert multiple rows to single row (multiple columns) in informatica

1109


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

733


What is difference between a gateway node and worker node?

832






source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2478


Design a mapping to load a target table with the following values from the above source?

1070


what is informatica metadata?

775


I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1675


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1731


What is parallel processing in informatica?

1266


Write the different tools in the workflow manager?

755


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1340


During the running session, output files are created by informatica server. Enlist few of them.

732


what is song in infrmatica...?

1905