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.

how to run 2 workflows sequentially. plz respond what is the process?

9 Answers   Cap Gemini, Target,

---

Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.

0 Answers  

---

We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??

2 Answers  

---

What is Performance tuning in Informatica?

1 Answers   CTS, GE, TCS,

---

Whats there in global repository

0 Answers  

---

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

0 Answers  

---

what is degenerated dimension?

1 Answers   IBM,

---

What is a taget load order?

2 Answers   IBM,

---

There are 2 files, Master and User. We need to compare 2 files and prepare a output log file which lists out missing Rolename for each UserName between Master and User file. Please find the sample data- MASTER.csv ---------- Org|Tmp_UsrID|ShortMark|Rolename ---|---------|----------|------------ AUS|0_ABC_PW |ABC PW |ABC Admin PW AUS|0_ABC_PW |ABC PW |MT Deny all GBR|0_EDT_SEC|CR Edit |Editor GBR|0_EDT_SEC|CR Edit |SEC MT103 GBR|0_EDT_SEC|CR Edit |AB User USER.csv -------- Org|UserName|ShortMark|Rolename ---|--------|---------|------------ AUS|charls |ABC PW |ABC Admin PW AUS|amudha |ABC PW |MT Deny all GBR|sandya |CR Edit |Editor GBR|sandya |CR Edit |SEC MT103 GBR|sandya |CR Edit |AB User GBR|sarkar |CR Edit |Editor GBR|sarkar |CR Edit |SEC MT103 Required Output file: --------------------- Org|Tmp_UsrID|UserName|Rolename |Code ---|---------|--------|------------|-------- AUS|0_ABC_PW |charls |ABC Admin PW|MATCH AUS|0_ABC_PW |charls |MT Deny all |MISSING AUS|0_ABC_PW |amudha |ABC Admin PW|MISSING AUS|0_ABC_PW |amudha |MT Deny all |MATCH GBR|0_EDT_SEC|sandya |Editor |MATCH GBR|0_EDT_SEC|sandya |SEC MT103 |MATCH GBR|0_EDT_SEC|sandya |AB User |MATCH GBR|0_EDT_SEC|sarkar |Editor |MATCH GBR|0_EDT_SEC|sarkar |SEC MT103 |MATCH GBR|0_EDT_SEC|sarkar |AB User |MISSING Both the files are mapped through Organization, Shor_mark. So, based on each Organization, Short_Mark, for each UserName from User.csv, we need to find the Matching and Missing Rolename. I am able to bring Matching records in the output. But really I don't find any concept or logic to achieve "MISSING" records which are present in Master and not in User.csv for each UserName. Please help out guys. Let me know if you need any more information. Note:- In User.csv file, there are n number of Organization, under which n number Shortmark comes which has n number of UserName.

0 Answers  

---

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers   TCS, Wipro,

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

0 Answers  

---

What is diff joiner and lookup

4 Answers   BirlaSoft,

---