Answer / moorthy. g

S-SQ-Exp-Rtr-Tgt1/Tgt2

Exp:

flag: decode(true, col1=prev_col1,'Y','N')
pre_col1=col1;

Rtr:
Group1 --- flag='Y' --- Tgt1 -- Duplicate Values
Group2 --- flag='N' --- Tgt2 -- Unique Values

Best Regards,
Manthiramoorthy. G

Answer / hema

With an Expression transformation flag the 1st record of a
group with some value say "VALID" and flag the other
records of the same group with value say "DUPLICATES". Then
pass this through a router and then to the different
Targets.(1st target - records with VALID flag and in 2nd
target - records with "DUPLICATES" flag)

Answer / shaik

Create a mapping with two targets.

> Create an Aggregator transformation and group it on the
distinct values and load it into Target1.

> Load the data directly in to Target2 since the source
have duplicates it will load all the duplicates.

Why use the lookup transformation ?

2 Answers   Informatica,

---

write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15

5 Answers   Tech Mahindra,

---

Explain load alternative records / rows into multiple targets - informatica

0 Answers   Informatica,

---

What is predefined event?

1 Answers  

---

What is the function of union transformation?

0 Answers  

---

hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me

3 Answers  

---

Explain the use of aggregator cache file?

0 Answers  

---

difference between informatica 8.1.1 and 8.6

0 Answers   TCS,

---

Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?

6 Answers   iFlex, Morgan Stanley,

---

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

3 Answers   Mind Tree,

---

What is update strategy transform?

0 Answers  

---

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

4 Answers   CSC,

---