Answer Posted / 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 View All Answers
What is the session task and command task?
Mention a few design and development best practices for informatica?
what is diff b/t sorter t/r and agg have the option sorter property...
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is joiner transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Can we create multiple integration service on single repository?
Explain in detail about scd type 1 through mapping.
How are indexes created after completing the load process?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Slowly changing dimensions, types and where will you use them
How are the sources and targets definitions imported in informatica designer?
What if the source is a flat-file?
Explain how to import oracle sequence into informatica?
What is a sorter transformation?
