Can we combine a flatfile and a database table using an
UNION transformation?
Answer Posted / kunkala ramakrishna
both the file and table metadata should same then we can join
Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
EXL informatica Questions
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is enterprise data warehousing?
What do you mean by filter transformation?
hi real timers . iam waiting for ur reply regarding ETL TESTING
As union transformation gives UNION ALL output, how you will get the UNION output?
What are the tasks that source qualifier perform?
Explain sql transformation in script mode examples in informatica
pmscmd startworkflow -sv
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is Cognos script editor?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is the way to execute pl/sql script using informatica mapping?
where to store informatica rejected data? How to extract the informatica rejected data?
Describe expression transformation?