Hi I am Vijay
In my source i've 10 records in a single column.... but i
want to split those records into 5 sequential files each
seq file contains 2 records.?.... can any body help me?
Answer Posted / aniket
another way is to use select statement ..
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Where the datastage stored his repository?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What is the roundrobin collector?
How many types of views are there in a datastage director?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
how to write server Routine coding?
What are the features of datastage flow designer?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Explain Quality stage?
What are the differences between datastage and informatica?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What are data elements?