Answer / nmlabsonline.net

Grouped cross tab means same as cross tab report particulary
grouped Ex:- emp dept tables take select row empno and
column in ename and group item deptno and cell select sal
then its comes
10
-------------------
raju|ramu|krishna|....
7098| 500
7034|
7023|600
--------------
20
......
....
like type ok

i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...

4 Answers   Keane India Ltd,

---

without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,

---

select count(1) from emp? what is the o/p?

5 Answers   TCS,

---

How can u work with remote database in informatica?did you work directly by using remote connections?

2 Answers  

---

can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

1 Answers   Puma,

---

Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u

3 Answers  

---

What is incremental aggregation and how it is done?

8 Answers   JPMorgan Chase, TCS,

---

How big was your fact table

0 Answers  

---

What are 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  

---

explain one complex mapping with logic? sales project?

0 Answers   Accenture, JPMorgan Chase,

---

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

8 Answers   HP,

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

0 Answers   CTS,

---