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
- 6846 Views
- I also Faced
- E-Mail Answers
Answer Posted / rahul
in exp trans take variable prot
v1 => first( custer ) as home
v2=> to store the previous value of customer
v3 = count = 1
v4 =. if ( customer = v2 , store its as office and count + 1)
v4 = if ( custmoe = v2 and count < 2 store it as other
else ' ')
i know till changes to be done..
its my guess
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the new features of Power Center 5.0?
How to join three sources using joiner?
is it possible to index the data in cache of lkp transformation ?
How to extract the informatica rejected data?
What are the uses of etl tools?
What are the types of schemas we have in data warehouse.
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Mention a few design and development best practices for informatica?
How are indexes created after completing the load process?
What is an aggregator transformation?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Explain where to store informatica rejected data? How to extract the informatica rejected data?
