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.

List the transformation in informatica.

1 Answers   TCS,

---

What is the difference between a table and the materialized view?

2 Answers  

---

what is target load plan

2 Answers   Cap Gemini,

---

why we use materialized view over view?

1 Answers   Zensar,

---

can you use flat file for lookup table?why?

2 Answers   HCL,

---

---

What do you understand by term role-playing dimension?

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,

---

Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

1 Answers   IBM,

---

what is mean by throghput? in informatica

3 Answers   Cap Gemini,

---

a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

0 Answers  

---

in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?

2 Answers   Cap Gemini,

---