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
What are the six data process products of ab initio (architecture of ab initio)?
What do you mean by a transaction file?
What is the difference between formal and export parameter? Export at what secenario we are going to use?
Why creation of temporary files depends on the value of MAX CORE ? How to use in abinitio graph? 10. What is the diff between abinitiorc and .abinitiorc files ? How to use in abinitio graph? 11. What is the use of allocate()? How to use in abinitio graph? 12. What is use of branch in EME ? 13. How you can break a lock in EME ? How can you lock a file so that only no one other than EME admin can break it ? How to use in abinitio graph? 14. When you should be using ablocal() ? How you can use ablocal_expr? How to use in abinitio graph? 15. Why you should not keep the layout as 'default' for input table component ? How to use in abinitio graph? 16. What is dynamic lookup ? How to use in abinitio graph? 17. What is dependent parameter ? How to use in abinitio graph? 18. What is BRE ? (Business Rule Environment - This is a recent addition in abinitio package) How to use in abinitio graph? 19.What is output index ? How to use in abinitio graph? 20. How you can track the records those are not getting selected from ‘select’ in reformat component ? How to use in abinitio graph? 21. Can we have more than one launcher process for a particular graph ? How about agent ? How to use in abinitio graph? 22. There are lot of new fuctions added in 2.15 , you can ask about them ? How to use in abinitio graph? 23. How can you run multiple instances of a graph in parallel? How to use
Do you think effective communication is necessary for data processing? What is your strength in terms of same?
What does de-partition mean in abinitio?
What are the reasons for which business can trust the approach of data processing?
What is broadcasting and replicate?
Have you used rollup component? Describe how.
How would you find out whether a sql query is using the indices you expect?
What are the benefits of data analyzing?
What is the difference between partitioning with key / hash and round robin?
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?
When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?
Have you worked with packages?