what are the transformations that restricts the partitioning of sessions?

1 Answers  

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

0 Answers  

---

How to load only the first and last record of a flat file into the target?

3 Answers   Mind Tree,

---

can session assigned multiple mappings or not?

2 Answers   Zensar,

---

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,

---

write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,

---

what is sql override?what is the use of it?

4 Answers   Sonata,

---

Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.

1 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  

---

If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 Answers  

---

What is the format of informatica objects in a repository?

0 Answers  

---

What is CDC? How to implement CDC?

4 Answers   People Tech, TCS,

---