Interested to Buy Any Domain ? << Click Here >> for more details...
Using Expression transformation how to remove duplicate
records from a relational source?
- 4 Answers
- 24664 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
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
When do you use sql override in a lookup transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
where to store informatica rejected data?
How can we use batches?
Mention a few design and development best practices for informatica?
What are the different types of olap? Give an example?
how tokens will generate?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
what is the size of u r source(like file or table)?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
While migrating the data from one environment to another environment how would you manage the connections?
Is it possible to define a single node as a Gateway node as well as worker node?
What are the different transaction levels available in transaction control transformation?
What is the use of source qualifier?
