Answer / sabyasachi

Parallei Query: To execute a query with the help of muliple
servers.
QueryHints: This are compiler directives to execute any
particular SQL query.This is generally done to override the
default mode in which the compiler is going to execute the
query.

How to convert IBM Cognos generated XML to a readable XML format for ETL tools

1 Answers  

---

i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers   HCL, HP,

---

Without using any transformations how u can load the data into target?

15 Answers   IBM,

---

Scheduling properties,whats the default (sequential)

0 Answers  

---

how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,

---

What is aggregate cache in aggregator transforamtion?

5 Answers  

---

get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c

3 Answers   Infosys,

---

What all join we can perform in LOOKUP transformation?

0 Answers  

---

when we dont use aggregator in mapping ?

2 Answers   CSC,

---

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,

---

if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.

2 Answers   IBM,

---

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  

---