Interested to Buy Any Domain ? << Click Here >> for more details...
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
- 2 Answers
- 6682 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ramu
The column which is used as a key prot in sorter should be
the group by port and check box sorted input in aggregator
t/r properties
| Is This Answer Correct ? | 15 Yes | 0 No |
What are connected or unconnected transformations?
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
What are the tasks that source qualifier perform?
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?
How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Enlist the various types of transformations.
how can i invoke pmcmd in command line prompt
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Teradata 
