Interested to Buy Any Domain ? << Click Here >> for more details...
in unconnected lookup , what are the other transformations ,
that can be used in place of that expression transformation ?
- 9 Answers
- 20334 Views
- Target, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / nagarjuna
Other than Expression we can call un connected
transformation from Update strategy transformation only
| Is This Answer Correct ? | 3 Yes | 3 No |
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 |
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 |
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 |
Answer / saran
Filter only used no other transformation cannot be used
..
| Is This Answer Correct ? | 0 Yes | 7 No |
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is sql query override? When did u use sql query override?
without dynamic lookup transformation how to insert new rows and update existing rows?
How can repository reports be accessed without sql or other transformations?
hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?
What is a candidate key?
To import the flat file definition into the designer where should the flat file be placed?
What is Index Caches size?
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
hw cn v elimate dublicate values from lookup without overriding sql?
What are the disadvantages of Sequence Generator T/R?
difference between stop and abort
Teradata 
