Answer Posted / moorthy g (ibm)

If your source is Flat file and Same Strcture then you can
go for indirect file type.
If source is relation file the you can use Source
Qualifier - Sql override or join condtion.
or Joiner Transformation(n-1)
=====
We Can join those tables in DB level.
(For Performance Tuning)

What do you mean by channel change?

965

---

What is the use of an aggregator cache file?

1139

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1986

---

What is blocking transformation?

1082

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2063

---

What are the tasks that source qualifier perform?

1029

---

What are the settings that you use to configure the joiner transformation?

1000

---

What is a pre-defined event and user-defined event?

972

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1974

---

What is a transaction control transformation?

1143

---

what is $$$$?

2097

---

Clarify the utilization of aggregator cache record?

943

---

What are the modules in Power Center

1621

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2313

---

What is a joiner transformation and why it is an active one?

998

---