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
Answer / karimulla
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|
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
|Is This Answer Correct ?||0 Yes||5 No|
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..........?
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
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?
HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?
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)
Explain the datastage parallel extender (px) or enterprise edition (ee)?
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...
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
what is the use of materialized view?
Different ways a project can be moved to production ?...example â€¦.export-import and Version control.
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What are the main features of datastage?