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

Answers were Sorted based on User's Feedback



if 3 table having different columes. like first table having 4 columns , second table having 3 col..

Answer / ajay

I am not sure abt the answer......but i think we can use
column generator for each of the inputs inorder to make
same metadata for all the 3 inputs bcos the prerequisite
for the funnel stage is metadata should be
same.........then we can funnel based on the key column

Is This Answer Correct ?    23 Yes 1 No

if 3 table having different columes. like first table having 4 columns , second table having 3 col..

Answer / sag

rajii in parallel jobs Transformer accepts only one input link
so u ranswer is wrong
think

Is This Answer Correct ?    15 Yes 1 No

if 3 table having different columes. like first table having 4 columns , second table having 3 col..

Answer / kalyanreddy

Hi Vyas,

Please ask the question properly....
Other wise you wont get right ans...

There are two posibilities
1.

table 1 has 4 col..
like
a,b,c,d
table 2 has 3 col..
like
a,b,c
table 3 has 2 col..
a,b

In this case funnel stage give only two output columns
(consider same metadata)
which are common in all the table ( in funnel stage no
properties are there for selecting common columns from
input).


2.

If Metadata is not same in above table change metadata in
transformer stage before using funnel based on requirement
only and consider datatypes of the columns.

Is This Answer Correct ?    12 Yes 1 No

if 3 table having different columes. like first table having 4 columns , second table having 3 col..

Answer / rajesh

to combined the data from 3 different files in funnel (same
meta data require )

Is This Answer Correct ?    8 Yes 0 No

if 3 table having different columes. like first table having 4 columns , second table having 3 col..

Answer / madhusudhan

If you want combine 3tables with different column name.
First use modify stage between source and funnel stage.
change the cloumns name in the 3tables into standard format.

or

you can try with transformer for creating new column name
for each table.

mailme if you have queries.
samala.madhu@gmail.com

Is This Answer Correct ?    8 Yes 2 No

if 3 table having different columes. like first table having 4 columns , second table having 3 col..

Answer / prasu

Put the transformer before the 2 tables which u have
lesscolumns.
and then add the remaning columns for the 2 tables.then
join with funnel stage

Is This Answer Correct ?    4 Yes 0 No

if 3 table having different columes. like first table having 4 columns , second table having 3 col..

Answer / anitha

haa.....Chowdary


if you don't know answer ,please don't give wrong answers.

i have given answer is wrong....

Is This Answer Correct ?    5 Yes 2 No

if 3 table having different columes. like first table having 4 columns , second table having 3 col..

Answer / moksha

in funnel stage meta data of all the input datasets must be
identical

Is This Answer Correct ?    2 Yes 0 No

if 3 table having different columes. like first table having 4 columns , second table having 3 col..

Answer / pavan

we can use column generator stage

Is This Answer Correct ?    2 Yes 0 No

if 3 table having different columes. like first table having 4 columns , second table having 3 col..

Answer / 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

More Data Stage Interview Questions

How can we run same job in 1 day 2 times

7 Answers   IBM,


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

17 Answers   IBM, TCS,


Hi All, I have a file. i need to fetch the records between first and last records by using transform stage. EX:- Source: EMPNO EMPNAME 4567 shree 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar 3265 Vishnu Target: EMPNO EMPNAME 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar I dont wan't to Shree and vishnu records.we can fetch another way also but How can I write the function in transform stage?

2 Answers   TCS,


Why we use surrogate key?

0 Answers  


Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?

1 Answers   TCS,






Is it possible to query a hash file?

0 Answers   IBM,


WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD

8 Answers   L&T,


What are iconv and oconv?

0 Answers  


how to call routines in stages?

3 Answers   ME,


What are the areas of application?

0 Answers  


What are the various kinds of the hash file?

0 Answers  


how will u design file watch jobs?

2 Answers  


Categories