Interested to Buy Any Domain ? << Click Here >> for more details...
Two source files contains same meta data third file
contains different data types can I funnel that file.
- 2 Answers
- 8033 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT?
How to display errors in datastage?
AGGREGATOR default datatype
how to run jon in unix back round process what is command use in runing a job?
Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.
my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?
What are the benefits of datastage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
what is the main differences between Lookup, Join and Merge stages?
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?
Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .
create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid salary previoussalary 10 1000 null 20 2000 1000 30 3000 2000 40 4000 3000
Teradata 
