Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / natrajdreams

Answers were Sorted based on User's Feedback



Hi Experts, I have a source table like this. Name Number Raj 2 Ram..

Answer / rayudu

Hi,

It can be done using Java Transformation.

In Java Code tab write the below code.

itr=in_number;

for(i=1;i<=itr;i++)
{
o_name=in_name;
generaterow();

}




Regatds,
Rayudu

Is This Answer Correct ?    7 Yes 0 No

Hi Experts, I have a source table like this. Name Number Raj 2 Ram..

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

Post New Answer

More Informatica Interview Questions

How to update a particular record in target with out running whole workflow?

0 Answers  

Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?

4 Answers  

.prm wirh repalce .txt is possible?

2 Answers  

what is data driven in update strategy transformation?

2 Answers   HCL, PayPal,

Suppose we do not group by on any ports of the aggregator what will be the output?

0 Answers  

I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers  

What will be the approach?

0 Answers  

What are batches?

0 Answers  

Briefly describe lookup transformation?

0 Answers  

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers   Cap Gemini,

How many dimensions are there in informatica?

0 Answers  

How do you take back up of repository?

0 Answers  

For more Informatica Interview Questions Click Here
Categories