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?
- 1 Answers
- 6071 Views
- Amdocs, I also Faced
- E-Mail Answers
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 |
How can we create index after completion of load process?
3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?
what are the differences between powercenter 8.1 and powercenter 8.5?
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
8.what is mapplet ?give example?
how to run the batch using pmcmd command
explain about lookup t/r?
what is correlated query?
1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.
Define mapping and session?
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Teradata 
