if 3 table having different columes. like first table
having 4 columns , second table having 3 columns and third
table having 2 columns then how to capture the data by
using funnel stage in parallel jobs...srinu.thadi
Answer Posted / srikanth reddy m
A.Use column generator stage for each of second and third tables for to generate extra columns as that of first table for to generate mock data and then use funnel stage finally to capture data from three tables.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how to delete one row in target dataset
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
what is ds administrator used for?
Difference between sequential file and data set?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Define repository tables in datastage?
State the difference between an operational datastage and a data warehouse?
How do you remove duplicate values in datastage?
What are the different options associated with dsjob command?
Describe routines in datastage? Enlist various types of routines.
how to write server Routine coding?
what is the difference between == and eq in UNIX shell scripting?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What is the difference between passive stage and active stage?