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
- 42650 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
Lookup constraints
How do you start developing a datastage project?
Explain how a source file is populated?
what are the errors,warnings in datastage
Differentiate between datastage and datastage tx?
what is use of SDR function?
What is merge stage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Differentiate between datastage and informatica?
On which Dimension Table you implemented SCD Type in your Project
How will you move hashed file from one location to another location?
Define meta stage?
What is orabulk stage?
What are the repository tables in datastage?
Can you explain repository tables in datastage?
