Interested to Buy Any Domain ? << Click Here >> for more details...
. Design a mapping, first two phone calls received by a
customer must be represented as "Home" , "Office" and the
next calls must be concatinated and represented as
"Other".Look at the below tables ::
Source Definition
Customer Phone_Number
A 9848403211
A 9812675432
A 9112356788
A 9876503276
B 9567890765
B 9876098567
AND THE TARGET IS
Customer Home Office Other
A 9848403211 9812675432 9112356788,9876503276
B 9567890765 9876098567 Null
- 3 Answers
- 6848 Views
- I also Faced
- E-Mail Answers
Answer Posted / maneesh
Aggregator can do this easily
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the types of schemas we have in data warehouse and what are the difference between them?
How are the sources and targets definitions imported in informatica designer?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is the advantage of informatica?
write a query to retrieve the latest records from the table sorted by version(scd)
What are active and passive transformations?
What does “tail –f” command do and what is its use as an Informatica admin.
Tell me about MD5 functions in informatica
What are the modules in Power Center
What is the use of an aggregator cache file?
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 dimensional table? Explain the different dimensions.
What is a predefined event?
What is meant by lookup transformation? Explain the types of lookup transformation?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
