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

in a table it has 200 rows the query is select 150 from tablename.whats the output

2 Answers   Cap Gemini,

How do you promote a non-reusable transformation to reusable transformation?

0 Answers   Informatica,

how to load only the first and last record of a flat file into the target?

8 Answers   CTS,

What are the Differences between connected and unconnected lookup?

6 Answers   TCS,

what is row level and column level indicator?

1 Answers   TCS,

i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....

4 Answers   TCS,

What are the different ways to implement parallel processing in informatica?

0 Answers  

How to load a relational source into file taget?

2 Answers  

Describe data concatenation?

0 Answers  

What are the databases that informatica can connect to windows?

0 Answers  

case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,

1 Answers  

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  

For more Informatica Interview Questions Click Here
Categories