Can we combine a flatfile and a database table using an
UNION transformation?

Answers were Sorted based on User's Feedback



Can we combine a flatfile and a database table using an UNION transformation?..

Answer / kunkala ramakrishna

both the file and table metadata should same then we can join

Is This Answer Correct ?    15 Yes 0 No

Can we combine a flatfile and a database table using an UNION transformation?..

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

Post New Answer

More Informatica Interview Questions

I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000

4 Answers   HCL,


how the informatica server sorts the strings values in rank transformations?

3 Answers   TCS,


What are the types of error logs available in Informatica?

1 Answers  


What is tracing level and what are the types of tracing level?

2 Answers   TCS,


there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source

2 Answers   TCS,


i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,


how DTM buffer size and buffer block size are related

3 Answers   Wipro,


If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,


what is diff between IN and EXIT commands

1 Answers   HCL, Schneider,


What are Rapid changing dimensions?

1 Answers  


Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)

1 Answers  


What is the Hierarchy of DWH?

1 Answers  


Categories