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
- 7714 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
How might one distinguish in the case of mapping is right or not without associating session?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What are the types of schemas we have in data warehouse.
Do you find any difficulty while working with flat files as source and target?
What are the types of caches in lookup?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
How is union transformation utilized?
Suppose we do not group by on any ports of the aggregator what will be the output?
Partition, what happens if the specified key range is shorter and longer
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What do you mean by channel change?
What is the use of code page?
What are the different components of powercenter?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
