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

4 yrs etl devloper roles and responsibilities?any body give solutions

2075

---

Explain in detail about scd type 1 through mapping.

1298

---

Explain the types of transformations?

1005

---

Define joiner transformation?

986

---

What do you mean by channel change?

965

---

Slowly changing dimensions, types and where will you use them

1654

---

What is repository manager?

930

---

How many input parameters can exist in an unconnected lookup?

1491

---

what is index?how it can work in informatica

1980

---

Briefly define reusable transformation?

1075

---

What are the reusable transformations?

1097

---

Explain informatica architecture - version 8 / 9

1021

---

What are the performance considerations when working with aggregator transformation?

1095

---

What is lookup change?

986

---

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1942

---