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
- 8301 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
Can you generate sequence numbers without using the sequence generator transformation?
What is dynamic cache?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
If informatica has its scheduler why using third party scheduler?
Explain load alternative records / rows into multiple targets - informatica
Explain the mapping variable usage example in informatica
Differentiate between router and filter transformation?
How to handle decimal places while importing a flatfile into informatica?
What is different between the data warehouse and data mart?
What's the layout of parameter file (what does a parameter file contain?)?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How to load data in informatica ?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Difference between Data and Index Caches?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
