Answer / rkumar.etl

use user defined join option.

what is correlated query?

2 Answers   IBM,

---

How you count the number of records available at your source?

3 Answers   Zensar,

---

if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,

---

How to go to the older version for a mapping?

0 Answers  

---

How can we use batches?

0 Answers  

---

if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?

2 Answers   TCS,

---

Discuss the advantages & Disadvantages of star & snowflake schema?

5 Answers  

---

How mapping parameter and variable works

1 Answers  

---

i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater

5 Answers  

---

in realtime which situations u can use unconnected lookup transformation

2 Answers   Patni,

---

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

0 Answers   IBM,

---

What are set operators in Oracle

3 Answers   Deloitte, Wipro,

---