Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / swap
You can write UNION ALL query in source qualifier
eg:-select NAME,EMP_ID from EMPLOYEE
UNION ALL
SELECT NAME,EMP_ID FROM EMPLOYEE
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How to load last n records of file into target table - informatica
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is the Process to creating lookup transformation in informatica
what is Active lock explain
What is substr in informatica?
what is the hint? how to use it to reduce the query processing in program?
What is an expression transformation?
Which transformation should we use to normalise the COBOL and relational sources?
In informatics server which files are created during the session rums?
whats the logic to load the lower level of granularity of data to fact table.
How do you convert single row from source into three rows into target?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Enlist few areas or real-time situations where informatica is required.
What does reusable transformation mean?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
