In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
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 |
How can you display only hidden files in UNIX
What is CDC? How to implement CDC?
suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is polling?
Which kind of index is preferred in DWH?
what is the necessity to use update strategy?(except for updates)
I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?
What is the Difference between DSS & OLTP?
I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...
HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?
without matching columns in two tables. how can you join