Answer / babu

u can write the filter condition in filter t/r.

in aggregator t/r select all ports are group by and add one
out put port,that is out--count(*),
in filter t/r u cam place the condition is out=1;

mapping:
src->sq->agg(t/r)->filtr or router t/r->trg

Answer / ramesh

this can achieved using Update statergy
we have option in UPD or Target update override

Answer / santosh kumar sarangi

1. If source is relational then in SQ you can check the
distinct or in mapping we can use distinct in sorter t/r.
2.if flat file then distinct in sorter t/r.

It will not allow nay duplicate data, so target will get
only distinct data.

Let me know if any thing wrong.

Thanks & regards
Santosh Kumar Sarangi

Answer / upendra

sq--> srtr-->aggr-->tgt

note:
srtr->properties->
select distinct and connect to aggr tr
aggr-->group by key column
aggr->properties->select sorted input
and connect to tgt

Answer / moorthy g [ibm]

1. Target Update Override
2. Select Unique Value (means)
Exp:
out_flag: decode( true, pre_no=no, 'Y', 'N')
pre_no = no

Router:
Out_flag: Y --- Unique Value
Default --- Duplicate Value

when we go for unconnected lookup transformation? and why?

5 Answers   Accenture,

how you will maintain version?

3 Answers   CTS, TCS,

how do u move the code from development to production?

6 Answers  

tell me about your project functionality

0 Answers  

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

3 Answers   Cap Gemini,

wat s mapping parameter and mapping variable? how do you set that in a mapping?

3 Answers  

Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga

2 Answers  

Write the advantages of partitioning a session?

0 Answers  

what is materialized view?

2 Answers  

how can one come to know wether the records loak into the target if we use update strategy

1 Answers   Wipro,

What is a joiner transformation and why it is an active one?

0 Answers  

update strategy transformation in informatica

0 Answers   Informatica,