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 |
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
How to extract original records at one target & Duplicate records at one target?
Explain pmcmd command usage in informatica
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
how to join two flat files in informatica?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Informatica and datawarehousing courses in Pune?
I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
What are the different types of transformation available in informatica.
What are the basic needs to join two sources in a source qualifier?