Using Expression transformation how to remove duplicate
records from a relational source?
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
Can we create multiple integration service on single repository?
What is joiner change?
Clarify the utilization of aggregator cache record?
What is the maplet?
Briefly describe lookup transformation?
Explain about cumulative Sum or moving sum?
What is resilience time?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is incremental aggregation?
Explain sessions. Explain how batches are used to combine executions?
What is a standalone command task?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Why filter transformation is an active one?
Why update strategy and union transformations are active? Explain with examples.
What is data movement mode in Informatica and difference between them?