Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Ab Initio
  2. Suggest New Category

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.

Question Posted / sree

Answers were Sorted based on User's Feedback



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..

Answer / krishna

we can use fuse component

Is This Answer Correct ?    6 Yes 1 No

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..

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

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..

Answer / enu

Another method we can also use interleave component which gathers data in round robin.

Is This Answer Correct ?    1 Yes 0 No

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..

Answer / apoorva

We can use Partition by round robin component with block size 1.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Ab Initio Interview Questions

I am having 10 records in i/p file,and i want to load only one record at a time to the output file.Then how can i do it?

2 Answers   IBM,

How you can test a dbc file ?

1 Answers   TCL,

What is the difference between Generate Records Component and Create Data Component?

6 Answers   Steria,

One file contains header,body,trailer records and header in a single row as well as trailer too.How to segregate these header,trailer and body records and once it gets segregated,i want to make the body data in reverse i.e if i have 10 body records,the 10th record should be the first record,9th record should be the second line,etc..

4 Answers   TCS,

what is macro?At what situation we have to face?

1 Answers  

What do you understand by a cartesian join?

0 Answers  

What is a data processing cycle and what is its significance?

0 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?

0 Answers  

Do we really work with ACTUALDATA in development phase.

4 Answers  

What is the return type of lookup_not_loaded() ? Does it return 0 or 1 to signify true or false or does it return index ...can someone please explain.

0 Answers  

What is the language used in Ab Initio ?

4 Answers  

Have you worked with packages?

0 Answers  

For more Ab Initio Interview Questions Click Here
Categories