When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
- 5 Answers
- 6783 Views
- I also Faced
- E-Mail Answers
Answer Posted / rascal
connected lookup is used when we need to use dynamic cache,we can return multiple o/p&need to use default values...otherwise if we want to use same lookup multiple times in the mapping then we go for un-connected lookup..In this case we can use only static cache..
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is the session task and command task?
Which means the first record should come as last record and last record should come as first record and load into the target file?
How to generate or load values in to the target table based on a column value using informatica etl tool.
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Explain scd type 3 through mapping.
Explain incremental aggregation in informatica
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Describe expression transformation?
What is a filter transformation and why it is an active one?
Explain how many types of dimensions are available in informatica?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Suppose we do not group by on any ports of the aggregator what will be the output?
What does refresh system mean, and what are its distinctive choice?
How big was your fact table
