Answer Posted / swetha
Join data originating from same source data base.
Filter records when the informatica server reads source data.
Specify an outer join rather than the default inner join
specify sorted records.
Select only distinct values from the source.
Creating custom query to issue a special SELECT statement
for the informatica server to read source data.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is data transformation manager process?
What happens when a session fails and you click on recover?
What is event and what are the tasks related to it?
What are the differences between oltp and olap?
Differences between connected and unconnected lookup?
What is decode in static cache?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
what are 3 tech challenges/ common issues you face?
What are the different transaction levels available in transaction control transformation?
What is powercenter on grid?
Define filter transformation?
Parameter and variable differences
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
server hot-ws270 is connect to Repository B. What does it mean?
