What is the difference between OLTP and ODS?

4 Answers  

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

0 Answers  

---

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers   Polaris, Zensar,

---

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in

1 Answers  

---

how to run the batch using pmcmd command

2 Answers   Wipro,

---

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,

---

suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer

1 Answers   TCS,

---

when we use dynamic lookup,if condition matches what will be the o/p?

2 Answers   L&T,

---

What is a router transformation?

0 Answers  

---

what are the row and column separations in Flat Files

3 Answers   CTS,

---

Can you copy the batches?

3 Answers  

---

What will be the approach?

0 Answers  

---