Interested to Buy Any Domain ? << Click Here >> for more details...
In aggregator if u enable sorted input what will be the
output and disable sorted wt is output
- 6 Answers
- 12691 Views
- I also Faced
- E-Mail Answers
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 |
Explain scd type 3 through mapping.
what is the logic will you implement to load data into a fact table from n dimension tables?
i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....
what is the main advantage of unconnected lookup
what is Partitioning ? where we can use Partition?
What are multi-group transformations?
wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35
What are the types of schemas we have in data warehouse.
difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?
What happens if the info. Server doesn't find the session parameter in the parameter file?
Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Teradata 
