in unconnected lookup , what are the other transformations ,
that can be used in place of that expression transformation ?
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 |
can we use self join in informaitca?
What is rank transform?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
can we see default group,when we use router?if yes how?
expain about the tune parameters?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What are connected or unconnected transformations?
How are indexes created after completing the load process?
what is the diff b/w target load plan and cbl?
my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
Differentiate between reusable transformation and mapplet.
what is diff between IN and EXIT commands