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

Please let me know how to make Data masking in informatica..

0 Answers  

---

What are the components of Informatica? And what is the purpose of each?

0 Answers   Informatica,

---

Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 Answers   TCS,

---

I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?

6 Answers   TCS,

---

What are the diffrences between joiner transformation and source qualifier transformation?

2 Answers  

---

---

Without source how to insert record to target?

6 Answers  

---

If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

2 Answers   TCS,

---

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  

---

Define Pmrep command?

0 Answers  

---

Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers   CSC, iNautix,

---

hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you

5 Answers   Patni,

---

If we set dd_insert in mapping and Delete in session properties what will happen.?

4 Answers   IBM,

---