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
- 6357 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / jz
select * from table_nme group by NO having count(*) > 1
or
Use Agg t/r group by on port 1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to update or delete the rows in a target, which do not have key fields?
What is a transaction control transformation?
How can you validate all mappings in the repository simultaneously?
What is meant by lookup transformation? Explain the types of lookup transformation?
How to elaborate tracing level?
what is the size of u r source(like file or table)?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
pmscmd startworkflow -sv
What are active transformations.
How to join three sources using joiner? Explain though mapping flow.
what is size of u r database?
What are the popular informatica products?
What are the guidelines to be followed while using union transformation?
What are the designer tools for creating transformations?
What is deployment group?
