in unconnected lookup , what are the other transformations , that can be used i

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

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

Question Posted / itsranjan

9 Answers
18043 Views
Target, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

in unconnected lookup , what are the other transformations , that can be used in place of that expr..

Answer / vishnu_kr

HI, UZVAL

PLEASE STATE HOW DO U USE UNCONNECTED LOOKUP FROM A SOURCE
QUALIFIER

IN MY KNOWLEDGE WE CAN'T USE U/C LKP IN SQ BUT WE CAN USE
IT IN OTHER TRFNs LIKE ROUTER, AGGR ETC.. WHERE EXPRESSIONS
EVALUATION IS ALLOWED.

PLEASE REPLY IF I AM WRONG.

Is This Answer Correct ?

5 Yes

2 No

in unconnected lookup , what are the other transformations , that can be used in place of that expr..

Answer / biswajit patra

Hi,
We can use only rank transformation, agg t/f ans we have to
call the unconnected lookup with in the transformation and
have to pass input values into it within that transformer

Is This Answer Correct ?

2 Yes

1 No

in unconnected lookup , what are the other transformations , that can be used in place of that expr..

Answer / nagarjuna

Other than Expression we can call un connected
transformation from Update strategy transformation only

Is This Answer Correct ?

3 Yes

3 No

in unconnected lookup , what are the other transformations , that can be used in place of that expr..

Answer / 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

in unconnected lookup , what are the other transformations , that can be used in place of that expr..

Answer / sid

I think we can use agg t/f and rank t/f for this
we cant use filter ,update strategy t/f becoz in these two
we wright the condition in conditions tab but not in ports .

Is This Answer Correct ?

4 Yes

6 No

in unconnected lookup , what are the other transformations , that can be used in place of that expr..

Answer / madhavan eyunni

Filter, Expression & update strategy

Is This Answer Correct ?

1 Yes

3 No

in unconnected lookup , what are the other transformations , that can be used in place of that expr..

Answer / abhishek

hey friends
we can use unconnected lookup with Exp
transformattion,update stragy, and as i remeber once i used
with filter

Is This Answer Correct ?

0 Yes

3 No

in unconnected lookup , what are the other transformations , that can be used in place of that expr..

Answer / uzval_vee

Filter,source qualifier

Is This Answer Correct ?

1 Yes

7 No

in unconnected lookup , what are the other transformations , that can be used in place of that expr..

Answer / saran

Filter only used no other transformation cannot be used
..

Is This Answer Correct ?

0 Yes

7 No

Post New Answer