What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

0 Answers  

---

in which situations do u go for starflake schema ?

6 Answers   TCS,

---

How can u insert o ne row in the target if that row does not exists in the target and update if it exists

6 Answers   Accenture,

---

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 the different caches used in informatica?

3 Answers   UST,

---

In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?

4 Answers  

---

1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.

5 Answers   CTS,

---

Which is the t/r that builts only single cache memory?

0 Answers  

---

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

0 Answers   TCS,

---

what are the limitations for bulk loading in informatica for all kind of databases and transformations?

3 Answers   Accenture, CSC,

---

suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,

---

How will the document be delivered to me?

0 Answers  

---