Interested to Buy Any Domain ? << Click Here >> for more details...
Using Expression transformation how to remove duplicate
records from a relational source?
- 4 Answers
- 24661 Views
- I also Faced
- E-Mail Answers
Answer Posted / bijay
The mapping should be like this
SRC->SQ->EXP->TARGET
In source qualifier transformation select 'ENABLE DISTINCT',
then it will send only distinct record to the expression transformtion. And From expression transformation simply connect to the target
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
How to generate or load values in to the target table based on a column value using informatica etl tool.
Whats the difference between informatica powercenter server, repositoryserver and repository?
What do you mean by channel change?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is a predefined event?
Differentiate between a repository server and a powerhouse?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Define joiner transformation?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
what is $$$$?
What are the components of workflow manager?
What is an expression transformation?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
difference between repository database and repository service?
In informatics server which files are created during the session rums?
