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

When do you use sql override in a lookup transformation?

1099

---

What are the components of Informatica? And what is the purpose of each?

1055

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4109

---

State the limitations where we cannot use joiner in the mapping pipeline?

1067

---

What is the use of transformation?

998

---

What is the need of etl tools?

1120

---

What is complex mapping?

1122

---

How do you use reject loader.

2605

---

What are the types of presistent cache in look up tr.

2055

---

define galaxy repository in informatica

2228

---

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9827

---

What is dimensional table? Explain the different dimensions.

1172

---

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4727

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2049

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1781

---