Answer Posted / guest
we can not have flat override in any of the Transormation.
We have only sql query here we can use the custom query for
relational sources and we have lookup override is there
here we can sql query for relational sources suppose we
going to lookup on relational table.
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
Explain incremental aggregation in informatica
What is joiner change?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is the procedure for creating independent data marts from informatica 7.1?
Explain pmcmd command usage in informatica
What is the sql query overwrite in source qualifier in informatica
What are the types of schemas we have in data warehouse and what are the difference between them?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is the function of look up transformation?
Write the unconnected lookup syntax and how to return more than one column.
How do you take back up of repository?
How do you update the records with or without using update strategy?
How to create the source and target database connections in server manager?
what is informatica metadata?
When do you use sql override in a lookup transformation?