Answer Posted / prabhu

Yes.we can.Use sqlplus -s command in unix to connect to
oracle from unix.Then we can execute the stored proc.

Prabhu
www.iskilltech.com

How to create a non-reusable instance of reusable transformations?

1063

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1851

---

explain abt ur project architecture?

2129

---

Is it possible to create multiple domains on a single Informatica server?

1188

---

What is an expression transformation in informatica?

972

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1925

---

What is the difference between a connected look up and unconnected lookup?

921

---

How many ways are there to do 'remove duplicate records in informatica'?

961

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

991

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

1995

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1041

---

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2403

---

What is the benefit of partitioning a session?

1113

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2213

---

What is sequence generator transformation in informatica?

1003

---