Interested to Buy Any Domain ? << Click Here >> for more details...
Using Expression transformation how to remove duplicate
records from a relational source?
- 4 Answers
- 24631 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 we use mapping variables in informatica?
What are the different versions of informatica?
What are mapplets? How is it different from a Reusable Transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
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
Why do you use Mapping Parameter and mapping variable?
Write the prerequisite tasks to achieve the session partition?
What are the features of complex mapping?
is it possible to index the data in cache of lkp transformation ?
What is rank transform?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Why sorter is an active transformation?
Briefly explain the aggregator transformation?
What is a snowflake schema?
