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
- 11649 Views
- L&T, I also Faced
- E-Mail Answers
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 is a cursor? Within a cursor, how would you update fields on the row just fetched?
What are the benefits of data analyzing?
What is a look-up?
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?
Can sorting and storing be done through single software or you need different for these approaches?
What is the difference between formal and export parameter? Export at what secenario we are going to use?
What is $mpjret?
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?
Describe in detail about lookup?
Can anyone give me an example of realtime start script in the graph?
How do you add default rules in transformer?
Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?
What do you mean by the term data warehousing? Is it different from data mining?
What information does a .dbc file extension provides to connect to the database?
How do you add default rules in the transformer?
