Answer Posted / kalyan

In SQL override (Source Qualifier level) write a query to
join the 2 tables like emp & dept as follows:

Select * from emp,dept;

The above query will return the cartesian product of the 2
tables; BTW, this don't have any condition...

Explain the features of connected and unconnected lookup.

544

---

Define pmcmd command?

620

---

What is a node in Informatica?

619

---

Explain sessions?

604

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4778

---

---

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

7797

---

What are the reusable transformations?

696

---

What is the need of etl tools?

609

---

How to open an older version of an object in the workspace?

616

---

What is informatica? Why do we need it?

641

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

599

---

What is the difference between router and filter?

647

---

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

1695

---

What is the function of aggregator transformation?

575

---

Explain direct and indirect flat file loading (source file type) - informatica

828

---