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
- 6 Answers
- 6353 Views
- IBM, I also Faced
- E-Mail Answers
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 all are steps in up gradation of Informatica server?
What is data caches/ index caches?
What is the meaning of decode in informatica?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is depict expression change?
Explain how many types of dimensions are available in informatica?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How an expression transformation differs from aggregator transformation?
What do you mean by channel change?
How you prepared reports for OLAP?
Where are the source flat files kept before running the session?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is resilience time?
Can we get 1st record through Informatica(without sequence number).
