how lookup is acting as both active and passive ?
how is it possitble?
- 9 Answers
- 57345 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / priyanka
hi
Suppose if we have 3 records with same key value, only then
first, last are considered. Based on given preference, if
it is first, it will consider the record which comes first.
If it is last, it considers the matched record which comes
by the end of that session.If there are no duplicate
records then,if there is a matched record it will return
the respective data for that record else with return NULL.
But, as it tracks all the records with some result i.e
either with its value or NULL, we consider it as passive
transformation
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What is joiner transformation in informatica?
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
How do you handle two sessions in Informatica
Explain the different dimensions.
How are indexes created after completing the load process?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
tell me the rules and responsblites in our project(my project is development)
What are the tasks that source qualifier perform?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Explain pushdown optimization and types in informatica
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Where do we use mapping variables in informatica?
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.
what is the complex transformation you used in informatica
How can you validate all mappings in the repository simultaneously?
