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

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.

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

5 Answers   HP,

---

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

---

What are the join types in joiner transformation?

1 Answers   Informatica,

---

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

2 Answers   IBM,

---

SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?

1 Answers   IBM,

---

On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records

1 Answers  

---

Could any one to tell Fact table Partitioning?

2 Answers  

---

What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .

1 Answers  

---

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

0 Answers   Amazon,

---

What are session parameters ? How do you set them?

0 Answers  

---

My source table having some records ,i want load 1st record and last record into one target?

3 Answers   iGate,

---

IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?

2 Answers  

---