.prm wirh repalce .txt is possible?

2 Answers  

---

why we are using level option in normalizer transformation

1 Answers   TCS, Wells Fargo,

---

Describe two levels in which update strategy transformation sets?

1 Answers  

---

surrogate keys usage in Oracle and Informatica?

5 Answers   ITC Infotech, Oracle,

---

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

0 Answers  

---

r u done any partitions in ur project?

0 Answers   TCS,

---

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

0 Answers   IBM,

---

in oracle write query yourname+1 from dual

5 Answers  

---

What is a parameter When and where do you them when does the value will be created

0 Answers  

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

---

why we use materialized view over view?

1 Answers   Zensar,

---

Can we insert ,update ,delete in target tables with one update strategy tran.?

2 Answers   Zensar,

---