Answer Posted / sachin

We can do it in two ways
1)in unix level.write a script to get the footer and header.
2)we can create 3 flows for header ,body and footer and append them one by one

COM components can be used in Informatica

2371

---

Differentiate between reusable transformation and mapplet.

1075

---

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2146

---

What is the function of look up transformation?

1112

---

What is native users?

1141

---

According to his methodology what all you need before you build a datawarehouse

1745

---

In which transformation you cannot drag ports into it?

1299

---

What is incremental aggregation?

1065

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10127

---

what is size of u r database?

2295

---

Describe the impact of several join conditions and join order in a joiner transformation?

1051

---

How can we improve session performance in aggregator transformation?

1097

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1028

---

How can we create index after completion of load process?

1109

---

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2023

---