Answer Posted / sarthak

With the help of command task...

cd dir_path
cat 1st_filename 2nd_filename >> 3rd_filename

Then,

create 1 flatfile and connect it to target.

In session property,
give the filename: 3rd_filename and its path

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

9116

---

Define filter transformation?

1092

---

Can you use flat files in Mapplets.

2648

---

How would you join a node to the already existing domain?

1125

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10677

---

Explain the difference between mapping parameter and mapping variable?

1033

---

Enlist few areas or real-time situations where informatica is required.

1080

---

Parameter and variable differences

2058

---

whats the logic to load the lower level of granularity of data to fact table.

2273

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1902

---

Design time, run time. If you don't create parameter what will happen

1835

---

How does a sorter cache works?

1065

---

Mention few advantages of router transformation over filter transformation.

1021

---

What is the session task and command task?

1052

---

How are the sources and targets definitions imported in informatica designer?

1100

---