With out using Funnel Stage, how to populate the data from
different sources to single target
Answers were Sorted based on User's Feedback
Answer / sravanthi menam
Create schema file for all source files and take dataset to read the files and enable RCP.In output dataset give append mode
| Is This Answer Correct ? | 1 Yes | 2 No |
I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know
How do you find the number of rows in a sequential file?
Can you explain repository tables in datastage?
How to initialize environment variables?
at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it
convert yyyy mm dd to dd mm yyyy?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.
INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?
What are the different plug-ins stages used in your projects?
How do u set a default value to a column if the column value is NULL?
SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS