Just keep one transformer stage before funnel stage.Three links(from thre

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

Question Posted / raji

17 Answers
43471 Views
IBM, TCS, I also Faced
E-Mail Answers

Answer Posted / raji

Just keep one transformer stage before funnel stage.Three
links(from three tables) should be coming as input for this
transformer. For the first link add the other tables
columns and so on.Make all the links have same number of
output columns. It should have same metadata definitions. i
mean these three links should contain all the 9 columns or
whatever it is.Now you can proceed further.

Is This Answer Correct ?

4 Yes

8 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1556

Notification Activity

1416

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)

2389

What a datastage macro?

1065

Define Data Stage?

1098

create a job that splits the data in the Jobs.txt file into four output files. You will direct the data to the different output files using constraints. • Job name: JobLevels • Source file: Jobs.txt • Target file 1: LowLevelJobs.txt − min_lvl between 0 and 25 inclusive. − Same column types and headings as Jobs.txt. − Include column names in the first line of the output file. − Job description column should be preceded by the string “Job Title:” and embedded within square brackets. For example, if the job description is “Designer”, the derived value is: “Job Title: [Designer]”. • Target file 2: MidLevelJobs.txt − min_lvl between 26 and 100 inclusive. − Same format and derivations as Target file 1. • Target file 3: HighLevelJobs.txt − min_lvl between 101 and 500 inclusive. − Same format and derivations as Target file 1. • Rejects file: JobRejects.txt − min_lvl is out of range, i.e., below 0 or above 500. − This file has only two columns: job_id and reject_desc. − reject_desc is a variable-length text field, maximum length 100. It should contain a string of the form: “Level out of range: ”, where is the value in the min_lvl field. My Question is how do you write the stage variable for reject rows.

2725

What is datastage?

1091

in oracle target stage when we use load option and when we use upsert option?

2285

How and where you used hash file?

1177

Differentiate between operational datastage (ods) and data warehouse?

1183

What is the differentiate between data file and descriptor file?

1366

How to RD using transformer?

1431

What are stage variables and constants?

1152

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2048

What are the various kinds of containers available in datastage?

1048