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 |
How to generate sequence numbers using expression transformation?
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
What is a code page?
what is upstream and downstream transformation?
how many types of dimensions are available in informatica?
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 Answers TCS, Tech Mahindra,
we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?
What is update override?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is the difference between normal and bulk loading? Which one is recommended?
how to duplicates from expression transformation without using sorter before that