Interested to Buy Any Domain ? << Click Here >> for more details...
when will we go for unconnected lookup transformation in
Informatica?
- 6 Answers
- 24255 Views
- CTS, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / suneelkumar.dasari
If u want to use the same look up T/R more than one time,you should use compulsory Unconnected lookup.A common use for unconnected Lookup transformations is to update slowly changing dimension tables.I know these 2 uses.
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / balu
above cases as well as if you want to get single port from
the lookup table then you should go for unconnected lookup
transformation.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / g. manthiramoorthy
1. Calling the same lookup multiple times in one mapping
2. Testing the results of a lookup in an expression
3. Filtering rows based on the lookup results
4. Marking rows for update based on the result of a lookup,
such as updating slowly changing dimension tables
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / naresh
If we want to use multiple times in same mapping you can go
for un-connected lookup and It depends on how much data
your processing.
performance wise unconnected lookup is better because its
like reusable one and it will lookup the values only the
condition meet the criteria.
1. It will return only one value
2. It will act as static cache
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / kamesh
The main advantage of using an unconnected lookup is the fact that you can use it in an expression/any other transformation like a “function” in other programming languages. The Lookup Cache is calculated only once as part of the session initialization and hence more efficient, since all subsequent look-ups will re-use the Cache.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nag
To retrieve the data dynamically. And it is used for other
transformations in the same mapping.
| Is This Answer Correct ? | 1 Yes | 12 No |
Can we update a target table (without primarykey) by using update strategy transformation?
Can we have a Mapping without a Source Qualifier?
How do you handle decimal places while importing a flatfile into informatica?
who to split dimentions into sub dimention
I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)
3 Answers Alcatel-Lucent, ECI Telecom,
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
What is the capacity of power cube?
how can we perform incremental aggregation?explain with example?
Teradata 
