Answer / bsgsr

populating null values inti not null columns,
expression errors in the expression editor,
pre n post sql errors,
overflow errors,
unique key constraint violation
and many such

reach me on bsgsr12@gmail.com

Answer / rao

mapping is invalid.database driver error .

how can we load first and last record from a flat file source to target?

7 Answers   Infosys, ITC Infotech,

---

Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.

1 Answers  

---

How to do the error handling of if ur source is flatfiles?

0 Answers  

---

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,

---

if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers   IBM,

---

What is parallel processing in informatica?

0 Answers  

---

what is the dashbords?

1 Answers   IBM,

---

Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.

2 Answers   CTS,

---

Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?

2 Answers  

---

How are parameters defined in informatica?

3 Answers   HP, TCS,

---

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

6 Answers   Accenture,

---

wat s mapping parameter and mapping variable? how do you set that in a mapping?

3 Answers  

---