Interested to Buy Any Domain ? << Click Here >> for more details...
when will we go for unconnected lookup transformation in
Informatica?
- 6 Answers
- 24808 Views
- CTS, IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain sessions and how many types of sessions are there?
Differentiate between source qualifier and filter transformation?
How you prepared reports for OLAP?
How does a rank transform differ from aggregator transform functions max and min?
In informatics server which files are created during the session rums?
How would you join a node to the already existing domain?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What are the different versions of informatica?
What is the need of an ETL tool?
How to join three sources using joiner? Explain though mapping flow.
How do you load unique records into one target table and duplicate records into a different target table?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Please let me know how to make encryption and decryption with example?
1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance
Why is sorter an active transformation?
