If we use sorted ports in aggregator transformation
and somehow records are not in order by format so what
will happen,session fails or it succeeded with incorrect data?
Answer / akhil4
session will be failed,when ever u enable the sort ports option u can use "sorter transformation" before "aggregator trns" that time session will be run.
| Is This Answer Correct ? | 5 Yes | 1 No |
What is the commit type if you have a transaction control transformation in the mapping?
How to eliminate duplicates from flat file..what is the procedure
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
Explain the flow of data in Iinformatica?
what are testing in a mapping level please give brif eplanation
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
how the server recognises , if the session fails after loading the 100 records in to the target
where is the reject loader .
In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data