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

Answer / sag

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

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.

Answer / rajesh

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

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

Answer / anitha

haa.....Chowdary


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

i have given answer is wrong....

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

Answer / moksha

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

Answer / pavan

we can use column generator stage

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.

how to sort two columns in single job in datastage.

1 Answers   TCS,

how can we join one oracle & flat files ?

2 Answers   ME,

I am running a job with 1000 records.. If the job gots aborted after loading 400 records into target... In this case i want to load the records in the target with 401 record... How will we do it??? This scenario is not for sequence job it's only in the job Ex: Seq file--> Trans--> Dataset..

9 Answers   Cognizant, IBM, TCS, Virtusa,

Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari

0 Answers  

there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities

2 Answers   Wipro,

1.What is a delta record? How you will read it? 2.What are the different types of sorting?

0 Answers   EDS,

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

0 Answers   Alpharithm Technologies,

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

4 Answers  

What are transforms and what is the differenece between routines and transforms?

0 Answers  

in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?

1 Answers   IBM,

How to create environments and call them? What is the use defined variables?

2 Answers   HCL, ME,

How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?

1 Answers