Answer Posted / sks

Hi,
Yes you can do it by using Expression transformation as
well. Infact, by using 2 SQ (source qualifier) and using
sql queries (as I explained earlier), you can perform the
required task on relational tables only (but not on flat
files etc).
In the case of flat files as source, you will need to use
Expression transformation. But you also need to use sorter
before expression (otherwise record flag will change for
every incoming record & duplicates won't be traced). The
sequence of transformations will be as follows -

Source -> SQ -> Sorter ->Expression ->Router(or 2 filters) -
>Targets

Mention a few design and development best practices for informatica?

1045

---

Under what condition selecting sorted input in aggregator may fail the session?

1175

---

What are the databases that informatica can connect to windows?

1096

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2254

---

What will be the approach?

1038

---

What is informatica metadata and where is it stored?

1043

---

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2094

---

How to delete duplicate row using informatica?

1089

---

How do we call shell scripts from informatica?

1191

---

How to load data in informatica ?

1068

---

Quickly characterize reusable change?

1184

---

How do you set a varible in incremental aggregation

1944

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2577

---

Reusable transformation and shortcut differences

1880

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2127

---