Interested to Buy Any Domain ? << Click Here >> for more details...
How can i catch the Duplicate Rows From SorterTrans in a
Seperate Target Table ?
- 2 Answers
- 8348 Views
- I also Faced
- E-Mail Answers
Answer Posted / krithi
When you use 'Select Distinct' option , the Sorter
Transformation discards the duplicate records.
If you want to trace out the duplicate records, then send
the sorted data into Expression Transformation. Add a new
variable and compare the variable with the input data. If
the data matches then flag the record or else pass the
default row.And load all the flagged records into a
seperate table.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Explain incremental aggregation in informatica
What are different types of transformations available in informatica?
What is expression transformation?
Describe the impact of several join conditions and join order in a joiner transformation?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
What is main use of mapplet?
Differentiate between a database and data warehouse?
Which files are created during the session rums by informatics server?
Explain scd type 3 through mapping.
What are the components of Informatica? And what is the purpose of each?
Where are the source flat files kept before running the session?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
what are the deliverables?in your project?
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 ?
