Answer Posted / shashank

in the normal loading the taget write all the row on the
database log , while laoading the bulk loading the database
log is not come in the picture (that mean its skip the
property )so when the session got failed we can easily find
recover the seesion by the help of data base log.but in
case of bulk loading we can do .

but normaol loading is very slow as compare to bulk laoding.

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1662

---

What are multi-group transformations?

569

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

637

---

what is the Default Source Option For Update Strategy Transformation?

762

---

What all are steps in up gradation of Informatica server?

624

---

---

What are the differences between a connected lookup and unconnected lookup?

654

---

How can we handle two sessions in informatica?

619

---

Differentiate between a repository server and a powerhouse?

583

---

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

1814

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

5843

---

What are active transformations.

1195

---

waht type of interface is used for testing the data in informatica

1838

---

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

1419

---

What is a stored procedure transformation?

611

---

How can you differentiate between powercenter and power map?

628

---