Answer / jafar

Hello;
I am not a DBA but I do not think you can use variables like
this. But I ran the SQL and the out put for them was the same:
ORA-00904: "X": invalid identifier
00904. 00000 - "%s: invalid identifier"
*Cause:
*Action:

You can do things like:
Select 1+1 from dual;
Select sysdate from dual
select sysdate - 300 from dual;
select user from dual;

Hope that helps.

Answer / shital.mylove@gmail.com

1.Unknown column 'x' in 'field list'
2.1
3.Unknown column 'x' in 'field list'

Answer / venkat

ans 1-->wrong number
ans2-->invalid number
ans3-->wrong number

What is difference macros and prompts?

2 Answers  

---

What are session parameters ? How do you set them?

0 Answers  

---

In session log thier should not be a single error how will u do

3 Answers   HCL,

---

Target is zero file and how can you send the email?

2 Answers   Bank Of America,

---

Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?

3 Answers  

---

i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers   HCL,

---

how to run 2 workflows sequentially. plz respond what is the process?

9 Answers   Cap Gemini, Target,

---

Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?

2 Answers   Infotech,

---

i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

7 Answers   L&T,

---

I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

8 Answers   DELL,

---

what is the size of ur database(like oracle)

2 Answers   HP,

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

0 Answers  

---