Interested to Buy Any Domain ? << Click Here >> for more details...
,if we have single SQ in flow and we have router in which it
has two group and we want to join these two groups with
joiner ?is it possible?
- 3 Answers
- 8152 Views
- Emphasis, I also Faced
- E-Mail Answers
Answer Posted / adithya amanchi
Router transformation is all about dividing data into group
of records based on one or more conditions. For example,
assuming a building as table with 10 floors considering each
floor as a record. The first three floors are for parking,
next three are for cinema halls and rest are for shopping.
It is nothing but making a vertical table into pieces.
Joiner transformation is nothing but depending upon common
columns(attributes or fields) or primary and foreign key
relationship combining two or more tables horizontally.
Making the table wider. similar to above example, joining
two buildings of different floors making one side of each
building as common.
hope this will help you guys
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
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 is a repository? And how to add it in an informatica client?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How identifying bottlenecks in various components of informatica and resolving them?
what is unit testing?tell me proceedure
How can informatica be used for an organization?
What are the types of caches in lookup?
How do you change a non-reusable transformation to reusable transformation?
What is dynamic cache?
What is a sorter transformation?
Is it possible to define a single node as a Gateway node as well as worker node?
What is a sequence generator transformation?
Explain constraint based loading in informatica
Define mapping and session?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
