Answer / abhinav prakash

There are multiple challenges while doing testing in Warehousing.
1.Checking if the sequence generator is throwing the correct the value
2.If we are using any FF as a source or target see to it that it has enough read and write permission.
3.Checking step by step if the required business login is implemented correctly(You can use the test load option)

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,

---

How can yoU create or import flat file definition in to the warehouse designer?

2 Answers  

---

can we use self join in informaitca?

3 Answers   IBM,

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  

---

i have source in oracle 10g,oracle 8i how will u take the data from two sources

2 Answers   TCS,

---

---

Can you start a session inside a batch individually?

2 Answers  

---

Do you have to change the reject file b4 using reject loader utility.

1 Answers  

---

What are the uses of a Parameter file?

3 Answers   CSC,

---

can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?

2 Answers   IBM,

---

Sequence generator, when you move from develoment to production how will you reset

0 Answers  

---

how many data models u have done in informatica project?

2 Answers   TCS,

---

What is a surrogate key?Why we use it in a mapping?Pl give an example.

4 Answers   PCS,

---