Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 43347 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
What is the method of removing duplicates, without the remove duplicate stage?
Differentiate between hash file and sequential file?
What is ds designer?
How to reverse the string using unix?
If you want to use the same piece of code in different jobs, how will you achieve it?
How do you remove duplicate values in datastage?
What is aggtorec restructure operator?
Is possible to create skid in dim,fact tables?
what is ds administrator used for?
On which Dimension Table you implemented SCD Type in your Project
What are the steps needed to create a simple basic datastage job?
What are stage variables?
What are the some differences between 7.x and 8.x version of datastage?
Differentiate between validated and Compiled in the Datastage?
What is the different type of jobs in datastage?
