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 |
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
Can we call a stored procedure from a unix script which is run using command task
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
How you prepared reports for OLAP?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
how will you get 21 to 30 record from 50 records?
HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com
How does a sorter cache works?