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 |
Define sessions in informatica etl?
what is metadata?
What are the issues you have faced in your project? How did you overcome those issues?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the types of schemas we have in data warehouse.
can we have to do changes in session property when we are dynamically generating target files?
can you please explain me pre session and post session options?
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
Can you access a repository created in previous version of Informatica?
Explain the types of lookup transformation?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
can anyone suggest best free Talend data integration training online