Answer Posted / ravi

pmcmd startworkflow -u ${infa_etl_user} -p ${infa_etl_passwd} -sv ${infa_etl_is} -d ${infa_etl_dom} -f ${folder_name} -paramfile ${parfile} -wait $workflowname

What is event and what are the tasks related to it?

1118

---

What are the guidelines to be followed while using union transformation?

1134

---

What are Dimensional table?

1053

---

define galaxy repository in informatica

2220

---

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

1956

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1971

---

How would you join a node to the already existing domain?

1123

---

Tell me about Propagate functions in informatica

917

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1089

---

Mention a few design and development best practices for informatica?

994

---

where to store informatica rejected data? How to extract the informatica rejected data?

998

---

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

1853

---

What are the new features of informatica 9.x developer?

968

---

What is complex mapping?

1115

---

What are junk dimensions?

1061

---