1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

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

plz explain in detail

Is This Answer Correct ?    0 Yes 0 No

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

Answer / naresh

Requirement is not clear ..can u please elaborate the
question(about metadata)

Is This Answer Correct ?    0 Yes 0 No

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

Answer / srinivas

funneling should have same meta data.
there r three types of funnel
1) continuous funnel
2) sort funnel
3) sequential funnel

Is This Answer Correct ?    0 Yes 0 No

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

Answer / krish

regarding this problem we can capture da common data only
which column are identical in all inputs.funnel receives
only common meta data fields from inputs & leaves un manched
meta data fields
ex;
let we have one field like a in t1 & field a's data like
1
2
3
4
then we have two field like a,b in t1 & fields a,b's data like
1 2
2,3
2,5
3,6

funnel data gives the out put only identical fields data like
1
2
3
4
1
2
2
3

Is This Answer Correct ?    1 Yes 1 No

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

Answer / sumit

You can achive this by using Column Import,Funnel and
Column Export stages.

Thanks

Sumit

Is This Answer Correct ?    0 Yes 2 No

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

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

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

Answer / chowdary

As:1
Frist you find common columen from the 3 table then you
can use funnel stage
in funnel stage set the properte KEY= COOMON COLUMEN

Chowdary

Is This Answer Correct ?    3 Yes 19 No

Post New Answer

More Data Stage Interview Questions

when u face critical situation in ur project, how to solve them?

1 Answers   Toyota,

Explain the ChangeApply stage?

11 Answers  

Wat is pre-load in Hashed file

1 Answers   Patni,

How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?

1 Answers   TCS,

EXPLAIN SCD

0 Answers   CTS,




What is usage analysis in datastage?

0 Answers  

Different ways a project can be moved to production ?...example ….export-import and Version control.

0 Answers  

source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235

6 Answers   US Technology,

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

0 Answers  

Why we use surrogate key?

0 Answers  

What are the types of hashed files in data stage

0 Answers  

explain unit testing,systemtesting,integrated testing

1 Answers   CSC,

For more Data Stage Interview Questions Click Here
Categories