Answer Posted / giri

Lookup connected,unconnected and Passive transformation. Looking for related values and inserting flake values.

Inserting Flag value

0 - No Change
1 - Insert
2 - Update

Can u generate reports in Informatica?

1091

---

What do you understand by a term domain?

1125

---

have u done any performance tuning? how u ll do?

2299

---

What is a repository? And how to add it in an informatica client?

1150

---

How can we create index after completion of load process?

1125

---

What is the need for an etl tool?

1068

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1087

---

Describe an informatica powercenter?

1127

---

What is an active transformation?

1113

---

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

---

What is meant by incremental aggregation?

1109

---

In which transformation you cannot drag ports into it?

1321

---

How to create or import flat file definition in to the warehouse designer?

1070

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2201

---

What is the difference between informatics 7x and 8x and what is latest version?

1085

---