how can we use sorter transformation in joins?
Answer Posted / sreekanth
to eliminate duplicates also sorter transformation is used
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How do you set a varible in incremental aggregation
How to delete duplicate row using informatica?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is a dimensional model?
scenario where i can use only concurrent execution of workflow.
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is powercenter on grid?
What is olap (on-line analytical processing?
What are the features of complex mapping?
How might one distinguish in the case of mapping is right or not without associating session?
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.
Write the program through which the records can be updated?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?