Answer / vivekk

Informatica is a Service Oriented Architecture, which means it has Client component and Server component.

In order to start the server, we need to start the services first. Lets see about the Server in regards with this question.

The server stores the meta data and not the actual data. It has Repository and Integration services. The Server components has multiple Domain and Node.

Each Node has those Repository and Integration services.

Repository services are used to design the code
Integration services are used to execute the code.

I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.

3 Answers   Amdocs,

---

Explain scd type 3 through mapping.

0 Answers  

---

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

3 Answers  

---

In which circumstances that informatica server creates Reject files?

2 Answers  

---

What is the diff. b/w informatica versions 8.1.1 and 8.6.1?

4 Answers   IBM, Wipro,

---

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

4 Answers   CSC,

---

what are the real time problems generally come up while doing or running mapping or any transformation?

2 Answers  

---

Does Facttable Normalized or Denormalized?

2 Answers   IBM,

---

Differentiate between router and filter transformation?

0 Answers  

---

In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?

3 Answers  

---

What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .

1 Answers  

---

how to get the data from the client machine and how to get server location data to client loction can any body explain to me

1 Answers   TCS,

---