Answer Posted / kittu

I think that is delimiters

What happens when a session fails and you click on recover?

1172

---

What the difference is between a database, a data warehouse and a data mart?

1199

---

What is a repository? And how to add it in an informatica client?

1192

---

How can you increase the performance in joiner transformation?

1248

---

what is diff b/t sorter t/r and agg have the option sorter property...

2230

---

What are the informatica performance improvement tips

1150

---

What is sorter transformation?

1108

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2249

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1690

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1336

---

what is song in infrmatica...?

2320

---

How many number of sessions can one group in batches?

1215

---

How to create Target definition for flat files?

1282

---

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

1908

---

What all join we can perform in LOOKUP transformation?

1019

---