Answer Posted / ajay pareek

first of all bad files and reject file both are same, there is no difference between them.
we call them reject fils that havving .bad extension.
there are not any files with .reject extension.
so the bad files or reject file keep the rejected records.

correct me if i am wrong

What are the different types of transformation available in informatica.

1147

---

Explain the different kinds of facts.

1023

---

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1100

---

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

2170

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2404

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1195

---

Is it possible to revert a global repository to local one and why?

1136

---

How can we remove the duplicates from flat file source?

1075

---

As union transformation gives UNION ALL output, how you will get the UNION output?

1160

---

What is incremental aggregation?

1137

---

how to create user defined function (udf) in informatica

1352

---

Explain informatica architecture - version 8 / 9

1153

---

What is target designer and target load order?

1171

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1212

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7185

---