In aggregator if u enable sorted input what will be the
output and disable sorted wt is output
Answers were Sorted based on User's Feedback
Answer / usha
when ever we r enable sorted input option in aggregator
transformation from source we should get data in sorted
form...
if not session fails
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / amedela chandra sekhar
if u enable sorted input option in aggregator with out group
by result is one row for all input records.
If u enable sorted input and group by session will fail.
Is This Answer Correct ? | 1 Yes | 0 No |
hi try this senario session will fail
Is This Answer Correct ? | 0 Yes | 0 No |
session will failed because it accepts only sorted input
Is This Answer Correct ? | 2 Yes | 6 No |
Answer / suneelkumar.dasari
If u enable the sorted input first of all burden on session will decrease and in sorted order aggregate data will come.
If u disable the sorted input port first first row type aggregate data and second row type aggregate date will come.But session won't fail.
Correct me if i am wrong.
Is This Answer Correct ? | 2 Yes | 6 No |
What is olap (on-line analytical processing?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
what is the look up transformation?
sorce is a flatfile only 1st and last row should insert to target how will u do?
Different qualification between a related rotate toward the sky and isolates look upward?
What is operational data source (ODS)?
What is meant by lookup transformation? Explain the types of lookup transformation?
how to delete duplicate records by using filter transfermation?
What is InformaticaPowerCenter?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?