Answer Posted / vamshi ch

U can do by using the expression.
Use variable var1.
Var1= IIF(SUBSTR( NAME_FIELD, 1, 1 )=R,1,0)

In Filter use the condition to filter var1=1.
Only the names starts with R will come as output.

Another way:
In source qaulifier write a query to filter the records
which starts with name 'R'.

Select * from Table where name like 'R%'

How do you load only null records into target?

738

---

What is a snowflake schema?

565

---

What is the maplet?

616

---

What is persistent lookup cache?

598

---

Scheduling properties,whats the default (sequential)

1460

---

---

What is meant by lookup transformation? Explain the types of lookup transformation?

565

---

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

2423

---

rank() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid order by case when opt2.dm_market_flg in ('Y', 'U') then 1 else 2 end, lkp.contact_rank) as rank1, case opt2.contact_type when 'Buyer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, ship_to_flg desc , last_order_dt desc) when 'Decision Maker' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc , last_quote_dt desc , mailability_score desc , source_ranking desc) when 'Influencer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) when 'Payer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) --elu 05/28/2013 else row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) end rank2 row_number() over (partition by opt3.dim_plat_site_id, opt3.dim_site_opt_sid order by rank1,rank2) as "rank", case when "rank"<= opt3.maximum_value then 'Y' else 'N' end as include_flg

1525

---

What does refresh system mean, and what are its distinctive choice?

564

---

what is song in infrmatica...?

1672

---

What is a mapplet/worklet in informatica?

682

---

Explian the Process of deployment groups in informatica

653

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

630

---

What is sorter transformation?

577

---

Explain why we use partitioning the session in informatica?

607

---