i have multiple .csv files in a unix directory. every file is having variable names as header.even for empty file also. suppose take 3 files a.csv b.csv c.csv a.csv contains data as name;age,salary; raja;34;4000; ravi;33;5000; kumar;25;3000; b.csv contains data as name;age,salary; ajay;40;4500; and c.csv contains name;age,salary; (only headers) Now i want to import and append all these files in to a single dataset. i tried infile statement with *.csv to import all at a time. but i m not getting correct data. please help me . its urgent. thank you in advance2 2094
Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool
Why do we need to convert categorical variables into factor? Which functions are used to perform the conversion?
Why can’t I go for something that is open source other than splunk?
How is the Implementation of Pythons dictionaries done?
What is the pressure of fuel oil on main engine and diesel generator?
How to compare two strings in perl?
What is an update type with reference to a match code id? : abap data dictionary
What are cluster in redshift? How do I create and delete a cluster in aws redshift?
can we get profile values in report without using user exists is it possible how?
how is the range of ip addresses defined for a windows server 2008 dhcp server? : Windows server 2008
you read newspaper regularly? What are some latest headlines?
What is django template language?
What is eddy current? Describe the operating principle of proximity probe.
What are the common values used in 2d transforms?
After doing realization how we will check whether it is working or not?