Answer Posted / ankit kansal

First of all Oracle supports implicit conversion between char to number if the specified text is of number type only.
*********************************************
Lets say sql>select '111'+1 as ans from dual;
ans
---
112
*********************************************
Here, 112 is the output you received it does not matter '112' as string.
But For precautions you can write your query as
***********************************************
sql>select to_number(trim('111'))+1 from dual;
***********************************************

Explain what is informatica metadata and where is it stored?

1051

---

What is parallel processing in informatica?

1714

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1125

---

What is the sql query overwrite in source qualifier in informatica

1090

---

What are pre and post-session shell commands?

1311

---

What is the difference between source qualifier transformations source filter to filter transformation?

1055

---

Please let me know how to make encryption and decryption with example?

1900

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4109

---

What is a grid in Informatica?

1071

---

What are active and passive transformations?

1086

---

what is diff b/t sorter t/r and agg have the option sorter property...

2179

---

What is the maplet?

1123

---

What is the advantage of informatica?

1069

---

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

9141

---

Whats there in global repository

1696

---