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
- 20782 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 |
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
What is batch and describe about types of batches?
Can I create one wrkflw which will run different wrkflws on schedule time?
How the dimensions will be loaded?
What are the new features of the server manager in the informatica 5.0?
How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 Answers TCS, Tech Mahindra,
where does the default group roew in a router is stored what is the default size of memory in router
explain about informatica server architecture?
source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.
What is domain and gateway node?
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
Teradata 
