Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 11619 Views
- L&T, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / enu
Another method we can also use interleave component which gathers data in round robin.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / apoorva
We can use Partition by round robin component with block size 1.
| Is This Answer Correct ? | 1 Yes | 1 No |
Need Ab-Initio Material - Harini
How to Improve Performance of graphs in Ab initio?
What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?
What dedup-component and replicate component does?
How will you use EME for view or publish metadata reports using EME?
How to create a repository in abinitio for stand-alone system(local nt)?
What is the difference between reformat and redefine format?
Mention what dedup-component and replicate component does?
Can someone tell me the behaviour of next_in_sequence() and innovation_number() in a multifile. Suppose I have records 1,1,1,2,2,3,4,4 in a 4ways mfs file. Data in each partition is: 0th : 1,1,1 1st : 2,2 3rd : 3 4th : 4,4 What will be the sequence of these records if I pass next_in_sequence() and innovation_number() ? Also how can I extract 3rd record from each of the 4 partitions of a 4way multifile through AbInitio? In unix we can use m_dump
. How we can remove temp files of a failed job if .rec is not available
What is rollup component?
Within a cursor, how would you update fields on the row just fetched?
Teradata 
