Answer Posted / kamleshmishra291

After SQ Take Aggr group by empid and create a variable port Rows_count=count(1)
Take a router after aggr and create two groups one for uniqe and one for duplicate
in uniqe condition = Rows_count=1
duplicate group condition= Rows_count>1
connect unique group to tgt1
connect duplicate group to java transformation---
add following codes
for (int i=0;i<count;i++)
{
o_empid=i_empid;
o_ename=i_ename;
o_loc=i_loc;
o_sal=i_sal;
generateRow();
}

connect java transformation to tgt2

tell me about your project functionality

2296

---

What is a sequence generator transformation?

954

---

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

1987

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1219

---

have u done any performance tuning? how u ll do?

2249

---

How can a transformation be made reusable?

1079

---

Explain how many types of dimensions are available in informatica?

1010

---

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

992

---

What is an Integration service in Informatica?

1085

---

What are the different lookup cache(s)?

1036

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3652

---

How to handle decimal places while importing a flatfile into informatica?

1134

---

Is it possible to use a client with different version than that of its Informatica server?

1077

---

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

8946

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1040

---