Can we combine a flatfile and a database table using an
UNION transformation?
Answers were Sorted based on User's Feedback
both the file and table metadata should same then we can join
Is This Answer Correct ? | 15 Yes | 0 No |
Answer / surya
You can connect heterogeneous sources to a Union transformation.The transformation merges sources with matching ports and outputs the data from one output group with the same ports as the input groups
Is This Answer Correct ? | 4 Yes | 2 No |
what is the command to get the list of files in a directory in unix?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is different between the data warehouse and data mart?
2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How will you update the row without using update statergy?
How do you do error handling in Informatica?
How can we use mapping variables in informatica? Where do we use them?
What are the active and passive transforamtions?
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
Write the unconnected lookup syntax and how to return more than one column.