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
Answers were Sorted based on User's Feedback
Answer / 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 |
How to use Normalizer transformation?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
How to display First letter of Names in Caps?
Consider a Phone Log table as below. It records all phone numbers that we dial in a given day. SOURCE_PHONE_NUMBER DESTINATION_PHONE_NUMBER CALL_START_DATETIME 1234 4567 01/07/2011 10:00 1234 2345 01/07/2011 11:00 1234 3456 01/07/2011 12:00 1234 3456 01/07/2011 13:00 1234 4567 01/07/2011 15:00 1222 7890 01/07/2011 10:00 1222 7680 01/07/2011 12:00 1222 2345 01/07/2011 13:00 Please provide an SQL query to display the source_phone_number and a flag where the flag needs to be set to Y if first called number and last called number are the same and N if the first called number and last called number are different. Desired Output: Source Number Is_Match 1222 N 1234 Y
how i will stop my workflow after 10 errors
without table how to come first record only in oracle?
In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?
how may sources can be used in a mapping at a time?(limit)
can we use self join in informaitca?
What is parallel processing in informatica?
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?