i have an aggregater in my mapping and no group by port on
any column and i ampassing 100 rows through aggregater,so
how many rows i will get as out put from aggregater
Answers were Sorted based on User's Feedback
Answer / sreenivas
it will return 100th row of the source if group by port is
not selected in aggregator
thanks,
sreenivas
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / pooja
all rows will come, since its not grouped. if its group by,
then last row will be out.
Is This Answer Correct ? | 3 Yes | 14 No |
What is Code Page Compatibility?
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
Explain the difference between mapping parameter and mapping variable?
My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.
Explain sql transformation in script mode examples in informatica
How can you define a transformation? What are different types of transformations in Informatica?
What is a code page?
What is facttable granularity?
where does the default group roew in a router is stored what is the default size of memory in router
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
What are the types of lookup caches?
10 Answers Accenture, IBM, Informatica,
Where can we find the throughput option in informatica?