Answer Posted / chandrasekar

Using unconnected lookup

How to generate sequence numbers using expression transformation?

1038

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1911

---

What is pmcmd command?

1053

---

complex mapping ur project u r invlve can u explain and give real time example give me ?

2249

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1750

---

Enlist some properties of sessions.

1034

---

What is meant by a domain?

1092

---

what is the -ve test case in your project.

2353

---

Explain what are the different types of transformation available in informatica.

1066

---

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

1820

---

tell me 5 session failure in real time how can you solve that in your project?

2213

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3660

---

r u done any partitions in ur project?

1770

---

can anyone explain me about retail domain project in informatica?

7902

---

What are the modules in Power Center

1639

---