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

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

0 Answers  

---

Difference between Target-based loading and constraint-based loading?

0 Answers  

---

Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.

0 Answers  

---

How the facts will be loaded? explain

2 Answers   HCL,

---

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values

6 Answers   TCS,

---

What are the different types of Type2 dimension maping?

2 Answers   CTS,

---

How to recover sessions in concurrent batches?

3 Answers  

---

How can we update a record in the target table without using update strategy?

0 Answers  

---

Explain the scenario which compels informatica server to reject files?

0 Answers  

---

I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.

1 Answers   Wipro,

---

in realtime which situations u can use unconnected lookup transformation

2 Answers   Patni,

---

on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

4 Answers   Fidelity,

---