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.

In Which scenario did u used Incremental loading?

2 Answers  

---

what are the challenge face in u r project?explain me

1 Answers   iGate, TCS,

---

What are the join types in joiner transformation?

1 Answers   Informatica,

---

What is the difference between Power Centre and Power Mart?

5 Answers   TCS,

---

what is meant by lookup caches?

2 Answers   Cap Gemini, Informatica,

---

I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 Answers  

---

i want excute multiple sessions in one workflow using the "start task".what do i need to do?

2 Answers  

---

what is mean by complex business rule ?

0 Answers   Cap Gemini,

---

In a table, 4 person having same salary. How to get Third person record only?

15 Answers  

---

Explain the difference between mapping parameter and mapping variable?

0 Answers  

---

What are the new features of Power Center 5.0?

0 Answers  

---

Define error Threshold?

1 Answers  

---