Explain grouped cross tab?



Explain grouped cross tab?..

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

Is This Answer Correct ?    2 Yes 10 No

Post New Answer

More Informatica Interview Questions

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

5 Answers   TCS,


what is the method of error handling when session is running?

1 Answers   TCS,


I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  


what is galaxy repository?

2 Answers  


How to update records in Target, without using Update Strategy?

3 Answers  


if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?

2 Answers   TCS,


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1 Answers  


I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers   Syntel,


what is upstream and downstream transformation?

7 Answers  


what is the difference between repository & Intergration service

1 Answers  


How can you change from reusable session into non-reusable session.

5 Answers   Cap Gemini,


Can anyone please distinguish what is Inner join and Outer join

2 Answers   Wipro,


Categories