Using Expression transformation how to remove duplicate
records from a relational source?
- 4 Answers
- 24028 Views
- I also Faced
- E-Mail Answers
Answer Posted / infabee
Expression is a passive transformation. So we can't delete
any row in it. We can achive only by using an active
transformation with/without it (SQ,Filter,Agg..etc).
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How can informatica be used for an organization?
Write the unconnected lookup syntax and how to return more than one column.
How we can create indexes after completing the loan process?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is a predefined event?
How many ways are there to do 'remove duplicate records in informatica'?
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?
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?
What is an Integration service in Informatica?
Describe the impact of several join conditions and join order in a joiner transformation?
What is a grid in Informatica?
How can we create index after completion of load process?
Explain what are the different versions of informatica?
How do you manage the Parameter files while migrating your data from one environment to another environment?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
