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 |
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
how the informatica server sorts the strings values in rank transformations?
What are the types of error logs available in Informatica?
What is tracing level and what are the types of tracing level?
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
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
how DTM buffer size and buffer block size are related
If a table contains 100 records we have to fetch 50-100 records from source to target?how
what is diff between IN and EXIT commands
What are Rapid changing dimensions?
Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)
What is the Hierarchy of DWH?