Input flatfile1 has 5 columns, faltfile2 has 3 columns(no
common column)
output should contain merged data(8 columns)
Please let me know how to achieve ??
- 3 Answers
- 7907 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sukanta
As per your question two files have same no of records
take first file's 5 column to a expression
transformation,add a output column in it let say 'A'.create
a mapping variable let say 'countA' having datatype
integer.Now in port 'A' you put expression like
setcountvariable(countA).
take second file's 3 column to a expression transformation
,add a output column in it let say 'B'.create a mapping
variable let say 'countB' having datatype integer.Now in
port 'B' you put expression like setcountvariable(countB).
The above two is only meant for creating common fields with
common data in two pipeline.
Now join two pipe line in a joiner transformation upon the
condition A=B.
Now join the required 8 ports to the target.
You get your target as per your requirement.
Regards
Sukanta
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / moorthy g
You Can create dummy port for each source Qual. then connect
to Join Trans., and Join two dummy port.in Joiner
Transformation.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / moorthy g
You Can Use Union Transformation for combine two flat files
| Is This Answer Correct ? | 1 Yes | 14 No |
What is the target load order?
ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
Explain what transformation and how many are there in informatica?
What is complex mapping?
Explain the scenario which compels informatica server to reject files?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
How many cubes create from a single model?
i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
Teradata 
