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 |
Explain the features of connected and unconnected lookup.
What is source qualifier transformation?
If u select groupby port in aggregator what is output and dont select groupby option what is output
i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need
Explain the informatica workflow?
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
What are the informatica performance improvement tips
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What happens if we dont select data driven option?
How to load the data from people soft hrm to people soft erm using informatica?
What are mapplets?