Without source how to insert record to target?

6 Answers  

---

Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?

18 Answers   L&T,

---

Can we insert ,update ,delete in target tables with one update strategy tran.?

2 Answers   Zensar,

---

i have source in oracle 10g,oracle 8i how will u take the data from two sources

2 Answers   TCS,

---

If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?

2 Answers  

---

what type of documents you receiving from client later wt can you do? what type of documents have to prepare?

2 Answers   CGI,

---

What exactly mentioned in High level design document.can somebody explain me sequentialy.

1 Answers   IBM,

---

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,

---

By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?

8 Answers  

---

In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?

5 Answers   Patni,

---

What is parameter file?

2 Answers  

---

What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .

4 Answers  

---