Interested to Buy Any Domain ? << Click Here >> for more details...
when will we go for unconnected lookup transformation in
Informatica?
- 6 Answers
- 24272 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
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
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
How to differentiate between the active and passive transformations?
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
What do you mean by worklet?
What are the different types of repositories created using informatica?
what is Active lock explain
What is the meaning of up gradation of repository?
What are junk dimensions?
how to load rows into fact table in data warehouse
Differentiate between source qualifier and filter transformation?
What are data-driven sessions?
How to extract sap data using informatica? What is abap? What are idocs?
What is the meaning of decode in informatica?
pmscmd startworkflow -sv
