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
- 6780 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
Explain transaction control transformation in informatica
What do you mean by worklet?
Can anyone tell me the new features in Informatica 9 Version?
Target increases every day even though no new record was inserted
what is mean by complex business rule ?
How many numbers of sessions can one group in batches?
What does refresh system mean, and what are its distinctive choice?
what is the size of u r source(like file or table)?
Explain the types of lookup transformation?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Mention some types of transformation?
How might you approve all mappings in the archive all the while?
How can informatica be used for an organization?
What is incremental aggregation?
What is meant by lookup transformation? Explain the types of lookup transformation?
