if we r using aggregator we enabled sorted input but the
records r not sorted what happen?
Answer Posted / deepthi
If u enable the 'sorted I/p'option in AGG tranformation,
power center server assumes that all data is sorted by
group.
If u use sorted i/p and dont use the sorted data session
fails.
| Is This Answer Correct ? | 17 Yes | 2 No |
Post New Answer View All Answers
What does “tail –f” command do and what is its use as an Informatica admin.
To import the flat file definition into the designer where should the flat file be placed?
COM components can be used in Informatica
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?
Name the different lookup cache(s)?
pmscmd startworkflow -sv
Plz can any one say me how to get the informatica certification materials and dumps
Briefly define reusable transformation?
How can we create index after completion of load process?
can u any challenge your project?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How to create a non-reusable instance of reusable transformations?
How many number of sessions can one group in batches?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.