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
The question was on time stamp. what is the difference between HH and HH24 when to use when.
I have a flat file, want to reverse the contents of the flat file
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is a dimensional model?
What is a connected transformation?
explain abt ur project architecture?
What is data transformation manager process?
How many ways a relational source definition can be updated and what are they?
What is the commit type if you have a transaction control transformation in the mapping?
Explain how to import oracle sequence into informatica?
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?
Define mapping and session?
How to Create a folder using pmrep command?
What you know about transaction control transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?