if the column name in sql override is diff from the column name in source qualifier,what is the impact?
Answer Posted / chandu
After over write we have to validate the rewrited query, So
when we click on validate It shows error message.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can you validate all mappings in the repository simultaneously?
What is the difference between writing a joiner query in ANSI style and THETA style?
Explain the tuning lookup transformation - informatica
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 are mapplets?
What is the different lookup cache(s)?
Differentiate between reusable transformation and mapplet.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Target increases every day even though no new record was inserted
How to join three sources using joiner? Explain though mapping flow.
What do you mean incremental aggregation?
Explain the different lookup methods used in informatica?
design of staging area?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Explain pmcmd command usage in informatica