Hi,
In source I have records like this
No name address
10 manoj mum
10 manoj dilhi
20 kumar usa
20 kumar Tokyo
I want records in target like shown below
No name addr1 addr2
10 manoj mum dilhi
20 kumar usa Tokyo
If it is reverse we can do this by using Normalizer
transformation by setting occurance as 2.
Somebody will say use denoralization technique. But as of my
knowledge I couldn’t find any denormalization technique. Is
there any concept like that?
I tryid this seriously but I could find any idea to
implement this.
Can any one please help me ?
Advance Thanks
Answer Posted / honey
I think this is the concept of scd type 3
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What if the source is a flat-file?
Did u used latest transformations of 8.6.0? for what?
What are the components of the workflow manager?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
How we can use union transformation?
Explain target update override in informatica
What is the benefit of session partitioning?
How many transformations can be used in mapplets.
What is a shortcut and copy in Informatica and how two are different with each other?
what are the deliverables?in your project?
Describe data concatenation?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
how to create user defined function (udf) in informatica
can u give example for factless fact table
Briefly describe lookup transformation?