Answer Posted / rajendra

I know only few difference

7.1:Java is not supported
No java source qualifier
8.1:Java is support
java source qualifier
Report generators(Not sure)

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1113

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2399

---

Explain constraint based loading in informatica

1076

---

What is confirmed fact in dataware housing?

6934

---

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

1842

---

What are session parameters ? How do you set them?

1831

---

Parameter and variable differences

2050

---

what is the difference between informatica6.1 and infomatica7.1

2256

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2023

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2547

---

Performance tuning( what you did in performance tuning)

1961

---

What is an expression transformation?

1001

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1495

---

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.

1263

---

How do you load first and last records into target table?

1144

---