Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?
Answer / teju
take source sequential file with 1 rec and take target file with 100 records in between use a copy stage to map the source 1 rec to target 100 records.
| Is This Answer Correct ? | 0 Yes | 0 No |
Where do you see different stages in the designer?
What are the types of containers in datastage?
In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?
Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?
What is oci?
what is time dimension? and how to populate time demension
on how many columns we can perform aggregation in the Aggregator stage?
i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME
What is the method of removing duplicates, without the remove duplicate stage?
i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?
what is the best stage in datastage parller jobs to use full out join and why
Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?
8 Answers Cognizant, HCL, TIAA CREF,