Answer Posted / ram

if dimensional table has repeat values

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1606

---

What are the data movement modes in informatica?

1082

---

Briefly explain the aggregator transformation?

943

---

What are the different options available for update strategy?

939

---

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2393

---

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

8946

---

What are the various types of transformation?

1097

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2469

---

Can u generate reports in Informatica?

1027

---

r u done any partitions in ur project?

1753

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1445

---

What are the differences between source qualifier and joiner transformation?

996

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1272

---

What are the components of the workflow manager?

1083

---

If informatica has its scheduler why using third party scheduler?

1196

---