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
- 20303 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 can we delete duplicate rows from flat files?
What is meant by target load plan?
What are the connected or unconnected transforamations?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?
What is Index Caches size?
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?
in what type of scenario bulk loading and normal loading we use?
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What are conformed dimensions?
Teradata 
