Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


Two source files contains same meta data third file
contains different data types can I funnel that file.

Answers were Sorted based on User's Feedback



Two source files contains same meta data third file contains different data types can I funnel that..

Answer / karimulla

Hello Friend,

In funnel stage the input metadata should be same.so it will
not work in funnel stage.

Is This Answer Correct ?    2 Yes 0 No

Two source files contains same meta data third file contains different data types can I funnel that..

Answer / ranjan

First we shouldnt do this. But still if you want to do then
we can take a transformer before funnel change the
datattype and conversion functions then funnel it and then
again take a transformer and change it to original datatype
and conversion.

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More Data Stage Interview Questions

one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?

8 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,


i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?

4 Answers   L&T,


HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?

1 Answers   HCL, IBM, Infosys,


This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)

2 Answers   CTS,






Explain the datastage parallel extender (px) or enterprise edition (ee)?

0 Answers  


Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...

5 Answers  


Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks

2 Answers   Cap Gemini, IBM,


what is the use of materialized view?

0 Answers   CTS,


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

0 Answers  


How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

0 Answers   Reliance,


What are the main features of datastage?

0 Answers  






Categories