Answer / jey.dgl

Using RegMatch in Informatica to validate

IIF(reg_match(in_Email,'^[a-zA-Z][\w\.-]*[a-zA-Z0-9]@[a-zA-Z0-
9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-
Z]$'),'Valid','Invalid')

what is data driven?

5 Answers   TCS, Wipro,

---

I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?

5 Answers  

---

tell me the rules and responsblites in our project(my project is development)

0 Answers  

---

how to get the data from the client machine and how to get server location data to client loction can any body explain to me

1 Answers   TCS,

---

with out using update strategy transnsformation how to update the data in mapping level

1 Answers  

---

What is confirmed fact in dataware housing?

2 Answers   Hewitt, TCS,

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

0 Answers   Wipro,

---

Target increases every day even though no new record was inserted

0 Answers   Accenture,

---

I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help

1 Answers   Axtria,

---

how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?

5 Answers   DELL,

---

scenario

1 Answers  

---

How to load the data from a flat file into the target where the source flat file name changes daily?

0 Answers   Informatica,

---