Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7867 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
Different qualification between a related rotate toward the sky and isolates look upward?
How might you approve all mappings in the archive all the while?
Make a note of the quantity vaults made in informatica?
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 identifying bottlenecks in various components of informatica and resolving them?
Define joiner transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How can you validate all mappings in the repository simultaneously?
What is a predefined event?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain in detail about scd type 1 through mapping.
What is the status code in stored procedure transformation?
how tokens will generate?
What is rank transform?
Is it possible to define a single node as a Gateway node as well as worker node?
