If we are using an aggregator but forget to mention the
group by port .what will be the output??
Answer Posted / sheelendra
I agree with Srinu.
and It will return only one aggregated value for all input.
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
what is index?how it can work in informatica
What is a code page?
What is rank index in rank transformation?
What is union transformation?
Briefly describe lookup transformation?
What is Data Caches size?
What does “tail –f” command do and what is its use as an Informatica admin.
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?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is option by which we can run all the sessions in a batch simultaneously?
What is rank transformation?