. 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
- 5725 Views
- I also Faced
- E-Mail Answers
Answer Posted / srinivas.medagum
WE CAN USE GROUP BY CUSTOMER
CONCAT(FIRST(Phone_Number).......>HOME
CONCAT(LAST(Phone_Number).......>OTHER
BUT HOW CAN I FETCH THE MIDDLE RECORDS?
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is Cognos script editor?
How to load a Dimension ? and how to load a fact table?
how many types of dimensions are available in informatica?
what is diff b/t sorter t/r and agg have the option sorter property...
Slowly changing dimensions, types and where will you use them
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
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
What do you mean by blocking transformation?
what is the hint? how to use it to reduce the query processing in program?
Repository user profiles
How does a sorter cache works?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is dynamic cache?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
