Answer / shake

Its is possible using regular expression in informatica

https://etltechsolutions.wordpress.com/

Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?

2 Answers   IBM,

---

SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?

1 Answers   IBM,

---

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

1 Answers   IBM,

---

I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.

3 Answers  

---

Can a joiner be used in a mapplet.

1 Answers  

---

What does “tail –f” command do and what is its use as an Informatica admin.

1 Answers  

---

How will you display "Mr" for male & "Mrs" for female in target table?

7 Answers  

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

0 Answers  

---

What are the measure objects?

1 Answers  

---

What did you do in source pre load stored procedure

1 Answers  

---

how did u understand business requirement?

2 Answers   TCS,

---

write a query to get maximum salary from the employers table without duplicates....kindly help me

5 Answers   CTS,

---