Interested to Buy Any Domain ? << Click Here >> for more details...
Hi Experts,
I have a source table like this.
Name Number
Raj 2
Ram 1
Sam 2
John 1
In the target I need the ouptput like the below
Raj
Raj
Ram
Sam
Sam
John
We dont know the number value . It will be changing as n..
Please help me regarding this.
Thanks,
Nataraj V
- 2 Answers
- 7859 Views
- NTT Data, I also Faced
- E-Mail Answers
Answer Posted / ganesh kumar
BY USING QUERY OVERRIDE IN SOURCE QUALIFIER
TO WRITE THE QUERY LIKE THIS
T_TEST UR SOURCE TABLE, NAME AND N_NUMBER UR SOURCE TABLE
COLUMN.
USING THE LEVEL PSEUDOCOLUMN TO GENERATE THE DUMMY ID(LEVEL
L)AND USING THE QUERY(DUAL TABLE) AS A INLINE VIEW AND THEN
JOIN(NON EQUIJOIN) THE CONDITION. FINALLY WE GOT THE RESUL
select t.name,t.n_number from t_test t,(select level l from
dual connect by level <= (select max(n_number) from t_test))
u where t.n_number>=u.l order by t.name;
SAME LOGIC USED FOR OTHER THAN RELATIONAL SOURCE AND THE
TRANSFORMATION.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is a filter transformation and why it is an active one?
What is enterprise data warehousing?
What is depict expression change?
What are the performance considerations when working with aggregator transformation?
Define filter transformation?
What is the advantage of informatica?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is meant by lookup transformation?
Difference between Data and Index Caches?
What is a connected transformation?
Explain the aggregator transformation?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How might you approve all mappings in the archive all the while?
What are the new features of Power Center 5.0?
