how to join two flat files in informatica?
Answers were Sorted based on User's Feedback
If the structure of the two flat files is same we can use SQ.by using in direct
if there is no common field in the two flat files then
create dummy columns in the exp t/r and then by using the dummy columns u can join them in the joiner t/r by giving the condition dummy = dummy1.
the flow is like this
src1--->SQ----->exp--->
|--->joiner---->target
src2--->SQ----->exp--->
Is This Answer Correct ? | 10 Yes | 0 No |
Hi Rajesh
could you plz tell me the steps to join from joiner tr.
Regards
Mehul Thakur
Is This Answer Correct ? | 0 Yes | 1 No |
Differentiate between mapping parameter and mapping variable?
What are the different components of powercenter?
Two Default User groups created in the repository are ____ and ______
Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.
1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach
How to view and Generate Metadata Reports?
my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
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?
How to add source flat file header into target file?
Is it possible to use a client with different version than that of its Informatica server?
What are the reusable transforamtions?
what is mapping parameter?