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 |
Different qualification between a related rotate toward the sky and isolates look upward?
I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance
What is session task and command task?
what is threshold error in informatica?
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
How to convert flat file into xml file? How to tune joiner?
empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.
Issue with Update override at Target table in Informatica.
Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.
How to display null values on a target & non-null values on a target?
in performance wise union is past,union all is past
Where do we use mapping variables in informatica?