Interested to Buy Any Domain ? << Click Here >> for more details...
Can we combine a flatfile and a database table using an
UNION transformation?
- 2 Answers
- 12706 Views
- Accenture, I also Faced
- E-Mail Answers
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 partioning?how many types of partinings are there
How to handle changing source file counts in a mapping?
What is dynamic cache?
In informatica workflow manager, how many repositories can be created?
How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?
1 Answers Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,
What does “tail –f” command do and what is its use as an Informatica admin.
Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?
If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???
we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?
Can you start a session inside a batch individually?
How to load last n records of file into target table - informatica
2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?
Teradata 
