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
- 9709 Views
- L&T, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 / 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 ? | 2 Yes | 1 No |
Answer / apoorva
We can use Partition by round robin component with block size 1.
| Is This Answer Correct ? | 1 Yes | 1 No |
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
What is the difference between sandbox and EME, can we perform checkin and checkout through sandbox?
5 Answers JPMorgan Chase, Syntel,
What is .abinitiorc and What it contain?
What are the differences between informatica and abinitio?
What are the different String functions used in Abinitio?
What is the function you would use to transfer a string into a decimal?
Describe what the SQL Server tempdb and tlog files are used for?
How to add default rules in transformer?
How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa
State the relation between EME, GDE and Co-operating system?
What is a ramp limit?
You can ask about - meta pivot, leading records, read & write multiple files component ? How to use in abinitio graph?
Teradata 
