Answer Posted / priyank

Except the 10 columns, if any other column is not being
used for any matching/filter condition, then remove the
columns from the look up table and the columns which are
used in the filter condition but are not taken forward in
the target, uncheck the oputput port and keep them as Input
port.

Tell me about Propagate functions in informatica

874

---

Explain sessions. Explain how batches are used to combine executions?

953

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2677

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1200

---

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

1985

---

How are the sources and targets definitions imported in informatica designer?

1050

---

What is aggregator transformation in informatica?

896

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1950

---

COM components can be used in Informatica

2313

---

How do you use reject loader.

2543

---

Explain incremental aggregation in informatica

1065

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1107

---

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1000

---

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

2314

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2058

---