how eliminate the duplicates in flat file with out using
sorter ,aggregater
Answer Posted / sanjay
here i m taking the example of employee table
first use the sorter to get the distinct value....
then use the agg trns, create the output port and use the
count function on employee_id to get the total no. of rows
like.. count(employee_id) and group by employee_id.
create filter trns.. write a condition where output>1... map
it with the target...
Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
what is mean by complex business rule ?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
difference between informatica 8.1.1 and 8.6
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What do mean by local and global repository?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is a grid in Informatica?
Describe an informatica powercenter?
What are the data movement modes in informatica?
How to use procedural logic inside infromatica?
Explain informatica architecture - version 8 / 9
What is union transformation?
Informatica settings are available in which file?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
wf dont have integration severances how you can run?