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

we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?

1 Answers   Polaris,

What are mapping parametres and variables in informatica?

6 Answers   TCS,

You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000

7 Answers   Deloitte,

Can anyone please distinguish what is Inner join and Outer join

2 Answers   Wipro,

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

0 Answers  

How do you convert single row from source into three rows into target?

0 Answers  

wat are deployement groups in informatica, how it will be used for developers

0 Answers  

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh

4 Answers   Accenture, TCS,

In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

1 Answers   Wipro,

In informatics server which files are created during the session rums?

0 Answers  

What is confirmed dimension and fact?

7 Answers