Answer Posted / gopinath

In Incremental loading the differnce between the source and
target are dumped at regular intervals. Here we give the
last extract date so that changes only of this particular
date will be loaded to the target tables.

What is meant by incremental aggregation?

1106

---

What are the informatica performance improvement tips

1093

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2184

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2158

---

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

2168

---

How we can create indexes after completing the loan process?

1211

---

Explain what is informatica metadata and where is it stored?

1050

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1796

---

What are the main features of Oracle 8i with context to datawarehouse?

2112

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1979

---

What are the different types of olap? Give an example?

1057

---

Explain pmcmd command usage in informatica

1132

---

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1946

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1675

---

During the running session, output files are created by informatica server. Enlist few of them.

982

---