Answer / sujana

v need to disable constraints while performing bulk loading

Answer / sunil

Bulk load is used for external loaders and in bulk load we
will not write information to datalog file so if any
recovery is needed it is not possible

Answer / vikas

1.update strategy
2.no constraints on target
3.target should be relational database
4.less number of records

expain about the tune parameters?

0 Answers   TCS,

---

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers   TCS,

---

what is the purpose of surrogate key and diff between primary key&surrogate key

1 Answers   Cap Gemini,

---

How will you check the bottle necks in informatica? From where do you start checking?

3 Answers   HCL,

---

what r the values tht r passed between informatics server and stored procedure?

1 Answers  

---

In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav

5 Answers  

---

In operator is used in which transformation in informatica 8.6.0

5 Answers   Virtusa,

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

0 Answers   Puma,

---

hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

1 Answers   Wipro,

---

wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,

---

Explain scd type 3 through mapping.

0 Answers  

---

Explain what transformation and how many are there in informatica?

0 Answers  

---