Answer / ali

if u config wrong relational coonnections in workflow manager, session failed.




2)if u enable bulk load without droping indexes in tgt table, run a session  the session get failed.




3)in workflow manager eventwait task waiting for particular time, then the indicator(file) not found, session get failed.




4)while sql override in s.q t/r,u miss any func in query, then (mapping valids) session failed? write  correct sql and execute it session succeess.




5)the tgt table has pk , but u r loading duplicated data  then session get failed( note:when u put 0 for "stop on errors" property it allows any number of non fatal errors)

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

0 Answers   Informatica,

---

How do you update the records with or without using update strategy?

0 Answers  

---

How you count the number of records available at your source?

3 Answers   Zensar,

---

i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

1 Answers   HCL,

---

What is a surrogate key?

0 Answers  

---

i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

6 Answers   Emphasis,

---

what is the look up transformation?

2 Answers   Informatica,

---

what is mapping override?

2 Answers   Cap Gemini,

---

which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?

3 Answers   Wipro,

---

What is the functionality of update strategy?

2 Answers  

---

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

6 Answers   Accenture,

---

 Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,

---