Answer Posted / hamza

delete id,name from tablename where id='null'

What is the use of target designer?

981

---

Why do you use Mapping Parameter and mapping variable?

1679

---

can we override a native sql query within informatica? How do we do it?

1051

---

What is a repository? And how to add it in an informatica client?

1083

---

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2078

---

explain abt ur project architecture?

2122

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1574

---

what is index?how it can work in informatica

1980

---

What does command task mean?

1063

---

What is difference between a gateway node and worker node?

1065

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1033

---

Define update strategy?

1112

---

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

1895

---

How can one identify whether mapping is correct or not without connecting session?

1368

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2073

---