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 are the types of data that passes between informatica server and stored procedure?
1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
4 Answers CompuSoft, EDS, TCS,
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
what are the transformations that restricts the partitioning of sessions?
What is the target load order?
Explain reference cursor?
what is diff between IN and EXIT commands
What does reusable transformation mean?
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
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Can you generate reports in Informatcia?