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 / ravi
can we get it by implimenting scd3 please correct me
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
if we have a delimiters at unwanted places in a flat file how can we over come those.
What are the components of Informatica? And what is the purpose of each?
Plz can any one say me how to get the informatica certification materials and dumps
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What are the new features of informatica 9.x at the developer level?
Is there any way to read the ms excel datas directly into informatica?
What do mean by local and global repository?
What is a transaction control transformation?
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
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Explain the difference between mapping parameter and mapping variable?
What is the difference between stop and abort in informatica
How can we create index after completion of load process?
COM components can be used in Informatica
Mention a few design and development best practices for informatica?