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


Please Help Members By Posting Answers For Below Questions

How can you validate all mappings in the repository simultaneously?

749


What is the difference between writing a joiner query in ANSI style and THETA style?

1910


Explain the tuning lookup transformation - informatica

605


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?

1309


What are mapplets?

807






What is the different lookup cache(s)?

603


Differentiate between reusable transformation and mapplet.

559


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?

5554


Target increases every day even though no new record was inserted

1100


How to join three sources using joiner? Explain though mapping flow.

684


What do you mean incremental aggregation?

617


Explain the different lookup methods used in informatica?

576


design of staging area?

1581


Name at least 5 different types of transformations used in mapping design and state the use of each.?

660


Explain pmcmd command usage in informatica

695