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

How to convert multiple rows to single row (multiple columns) in informatica

0 Answers   Informatica,

---

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

---

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

1 Answers   Accenture,

---

how can u load the data in time dimension?

3 Answers  

---

how may sources can be used in a mapping at a time?(limit)

6 Answers   IBM,

---

how to join two flat file if they have diff. structure?how to join one relational and one flat file?

4 Answers   Wipro,

---

Define filter transformation?

0 Answers  

---

what are the transformations that are used in data cleansing ? and how data cleansing takes place ?

3 Answers  

---

my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers   KPIT,

---

How to do the error handling of if ur source is flatfiles?

0 Answers  

---

What are the main issues while working with flat files as source and as targets ?

0 Answers   Informatica,

---

What is the difference between IN and Exists in Oracle?

4 Answers   Deloitte,

---