Interested to Buy Any Domain ? << Click Here >> for more details...
hw cn v elimate dublicate values from lookup without
overriding sql?
- 7 Answers
- 17748 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / honey
We can remove the duplicate values from the lookup by using
the DISTINCT clause with SQL queries.
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
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?
What are the types of presistent cache in look up tr.
What is an active transformation?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Explain about cumulative Sum or moving sum?
According to his methodology what all you need before you build a datawarehouse
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
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?
Can informatica load heterogeneous targets from heterogeneous sources?
What are the different lookup cache(s)?
How can you define user defied event?
What is xml source qualifier transformation in informatica?
Can you use flat files in Mapplets.
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Explain constraint based loading in informatica
