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
- 42593 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 steps should be taken to improve Datastage jobs?
What are the difference types of stages?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What are the different common services in datastage?
Lookup constraints
Have you have ever worked in unix environment and why it is useful in datastage?
Terminate Activity
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What all the types of jobs you developed?
What are routines in datastage?
Highlight the main features of datastage?
Explain connectivity between datastage with datasources?
How do you run datastage job from the command line?
Distinguish between informatica & datastage. Which one would you choose and why?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
