1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / itsranjan

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

More Informatica Interview Questions

what are the unix commands to start the wrk flow ?

4 Answers   Accenture, TCS,

version controlling in informatica?

3 Answers  

What is an Integration service in Informatica?

0 Answers  

select count(1) from emp? what is the o/p?

5 Answers   TCS,

If u select groupby port in aggregator what is output and dont select groupby option what is output

2 Answers  




how can u tune u r informatica mapppings

2 Answers   CTS,

What is a joiner transformation?

0 Answers  

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

5 Answers   Wipro,

what is diff b/t sorter t/r and agg have the option sorter property...

0 Answers  

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

0 Answers   IBM,

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

0 Answers  

how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,

For more Informatica Interview Questions Click Here
Categories