i have 2 files. First file contains a,b,c,d as rows and second file contains 1,2,3,4 as rows. how do we make single a1b2c3d4 and 4 different rows a1, b2, c3,d4.
Answer Posted / jatin chawla
1. Use fuse component to join two files and will give output
col1 col2
a 1
b 2
c 3
d 4
Then in Reformat do out.col :: string_concat (col1,col2)
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?
How abinitio eme is segregated?
Can you explain data flow graph with an example?
What is the difference between look-up file and look-up, with a relevant example?
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?
What is a look-up?
What are the co> operating system’s assorted library of integrated components?
What do you understand by overflow errors?
Explain what is sandbox?
What does de-partition mean in abinitio?
List out the file extensions used in abinitio?
How would you find out whether a sql query is using the indices you expect?
How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on
Difference between informatica vs ab initio?
What is the use of the co> operating system in ab initio?