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
- 37697 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
Name the third party tools that can be used in datastage?
What is process model?
What is the difference between hashfile and sequential file?
Terminate Activity
Enlist various types of routines in datastage.
What is the project in datastage?
On which Dimension Table you implemented SCD Type in your Project
how to write server Routine coding?
What is a quality stage in datastage tool?
How complex jobs are implemented in datstage to improve performance?
How you Implemented SCD Type 1 & Type 2 in your project?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What is apt_config in datastage?
What are some prerequisites for datastage?
