Answer Posted / sanjay

well if u hav all related sources then u can probably go
for joiner but make sure that use less no. of joiner as it
may decrease your performance.
if u hav sources with same structure and data types then u
can probably go for set operation and matchin it with your
target.
the third one is u hav to do a lot of transformation based
on some analysis and might be u can create differnet
aliases for your target and you can apply your
transformation.


plz let me know if any clarification . your comment will be
appreciatable. :)

Where can we find the throughput option in informatica?

995

---

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

8934

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1714

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2051

---

What is workflow monitor?

995

---

Write the advantages of partitioning a session?

1200

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1194

---

How to do the error handling of if ur source is flatfiles?

1908

---

Describe an informatica powercenter?

1034

---

scenario where i can use only concurrent execution of workflow.

3061

---

Can we create a node as a gateway node and the same node can be assigned to a grid?

1025

---

How many transformations can be used in mapplets.

1867

---

What is session task and command task?

1174

---

What are the components of the workflow manager?

1078

---

What are ETL Tools?

1039

---